Please post the SQL. Open the query in design view, then click View SQL.

It could be that you are specifying 0 for Null values. Null is not the same
as 0. You could start by using 0 in one criteria line of the query, and in
the "Or" line directly below it, Is Not Null.

Coco111 wrote:
Hi,

I got some problem, I check a lot of past thread and can find similar
question but not exactly the problem that I face. Anybody can tell me how to
hide zero values in report. My report comes from Queries. Qty On Hand: [Qty
Purchased]-[Q'ty Sold], I put criteria in queries 0 but, it did not work.
Message show Qty Purchase? and also Qty Sold? How? Please help?
Thks in advance...

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...esign/200911/1