View Full Version : Need help with query


wilkob
05-04-2007, 02:28 AM
I have a table with open order items:

Order No - Order Item - Product - QTY - Stock Reservations - Incoming Reservation

I would like to create a query which shows me all order items that haven't got a stock reservations nor an incoming reservation

Can someone help me with this one

MStef
05-04-2007, 03:22 AM
Try in query criteria;

Is Null