Append Query Question

[Thor]

I'm working on this inventory database. So I have a select query called "trigger query" that lets me know what items need to be orderd. Then I have an append query that adds those items to a table called ORDERS.

From the trigger query, I have the fields Item Number (which is a primary key in a table called ITEMS), Order Quantity, as well as Order date and date expected which are calculated fields.

In the ORDER table there is also an order number(primary key auto number) field, and a boolean field called Pending.

So what I want to do in this append query is to keep it from appending an item that the trigger query says needs to be ordered, when an order for that item is already pending. I'm not sure how to specify that in the criteria of item number in the append query (or if thats even a good way to go about this).

 

[KeithG]

You can do this, in your Append query you need use a Left join from your Trigger query to the Orders table on ItmID field. Then include the Pending field in your query but do not put anything in the Append To field. In the criteria field put 0 or IsNull.

 

[Thor]

That did the trick. Thanks a lot KeithG.