Append Query Help

[Kelsey]

I am wanting to use an Append Query to append records from one database to another. I am having problem with deciding on criteria to append only the records that haven't already been appended to the second database table.

Query:
IssueQuantity
InventoryID
Cost
PurchaseOrderDetailID
Job ID

Second table:
ReceivingID
InventoryID
ReceivingQuantity
Cost
ReceivingDate
PurchaseOrderDetailID

I will be opening the append query sometime in the form frmIssueNew. I only need to Append the records that have a JobID of 22, and haven't already been appended.

Any help on the criteria for this is appreciated! thanks!

 

[MSAccessRookie]

I am wanting to use an Append Query to append records from one database to another. I am having problem with deciding on criteria to append only the records that haven't already been appended to the second database table.

Query:
IssueQuantity
InventoryID
Cost
PurchaseOrderDetailID
Job ID

Second table:
ReceivingID
InventoryID
ReceivingQuantity
Cost
ReceivingDate
PurchaseOrderDetailID

I will be opening the append query sometime in the form frmIssueNew. I only need to Append the records that have a JobID of 22, and haven't already been appended.

Any help on the criteria for this is appreciated! thanks!

Take some time to look into the EXISTS Clause for SQL Statements, and see if that will help you out.

http://allenbrowne.com/subquery-01.html