General discussion
January 7, 2005 at 09:27 AM
senftk

Help with Access / SQL

by senftk . Updated 21 years, 9 months ago

I have a table in access called retailers.
I want to build a query that will only return records where the Cost – payments made is >0
fields involved are [COST],[PAY AMOUNT 1],[PAY AMOUNT 2],[PAY AMOUNT 3],[PAY AMOUNT 4]

Here is what I tried and it returns no records even though there are records that match this criteria:

SELECT*
FROM Retailers
WHERE [COST]-[PAY AMOUNT 1]-[PAY AMOUNT 2]-[PAY AMOUNT 3]-[PAY AMOUNT 4] >0

Can someone clue me into the proper SQL statement needed?

This discussion is locked

All Comments