Access query HELP!

[rlh1963]

Have a query that shows customer [Total Due]-[Amount Paid] to get a balance. Is returing the balances but is also returing all the 0.00 balances. I only want the ones that have a balance due but can not figure out how to do this. Propably a really easy solution. Please help!

[orange]

Add criteria/filter

([Total Due]-[Amount Paid]) > 0

but assumes nobody has OverPaid (negative balance)

[rlh1963]

Ok, just pasted that in my criteria, have tried this before and it will not give me any records then. Ask for parameter for [Total Due] and [Total Paid]. Not sure why am getting this, any ideals?

[orange]

Please show the sql for your query.

[rlh1963]

Please look at next

[rlh1963]

Can I send it to your e-mail to look at?

[orange]

Did you try to paste it in your message directly?

[rlh1963]

Yes would not paste for some reason. Is there another way to do it?