Criteria problem

[AnnPhil]

i have a query that works great until i put in simple criteria. when i put the criteria it prompts me with a "Enter Parameter Value" screen. The field with the criteria is a calculated field such as RemBal:[costs]-[payments]. When i put >0 for the criteria i get the prompts. When i take the criteria out it shows all records and i only want records with a remaining balance.

Any suggestion why this would happen?

 

[Graham T]

Hi Ann

Not sure why you're getting this as I have tried and had no problems. Your SQL should look like:

SELECT "TABLENAME".costs, "TABLENAME".payments, [costs]-[payments] AS RemBal
FROM "TABLENAME"
WHERE ((([costs]-[payments])>0));

This should then work.

Graham