RESOLVED

Check the following link if interested:

http://www.merlinaccounts.co.uk/sql2.jpg

Could it have something to do with the joins?

Any ideas folks? I refuse to be beaten on this one, and I'm 99.9% certain its "do-able!"

Here is the screen shot:

Sorry,

the picture in the message above was meant to include a screen shot of the query builder. I won't have access to the pic again until tonight. I will repost...

How would I go about identifying those?

My aim in the above was to transfer values from one table (Purchase_Invoices) into three tables, Purchase_Invoice, Transaction, and Purch_Inv_Transaction.

I want to query the...