I try it as you told me but still not work.

In criteria I put 0 and below line Or, I put, Is Not Null
F.Y.I, i use northwind template and i did not change anything.

How can I solve this problem?

BruceM wrote:
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.

Hi,

[quoted text clipped - 4 lines]
Message show Qty Purchase? and also Qty Sold? How? Please help?
Thks in advance...

--
Message posted via http://www.accessmonster.com