Please post the SQL as described in my previous posting.

Coco111 wrote:
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?

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

[quoted text clipped - 7 lines]
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