Hi all - Good morning
I am trying to do an append query to only append new records (QryAttached)
I have watched several video and read a whole bunch of references yet i cannot get this to append only new records.
If I do it the way some vidoes show me i get an error message.
With that said, left table is the info I want to append to the right table. I added a # field in right table (TableID) as wouldnt work with the actual auto id.
The existing query actually works but creates duplicates if run over and over...
Any help with this would be so kind. I have three tables, (Purchase, Payment, and Deposit) that I need to append into this same table so i can create reports from one table
with deposits and withdrawals and such....In case you are curious
Design View
Sql
Code:
INSERT INTO tblCatagoryDetail ( [TableID], AccountID, CatagoryTypeID, CatagoryID, SubCatagoryID, Withdrawal, Travel, SubCatagoryName, TransactionID, TransDate )
SELECT DISTINCTROW tblCatagoryDetailPurchase.CatagoryDetailPurchaseID, tblCatagoryDetailPurchase.AccountID, tblCatagoryDetailPurchase.CatagoryTypeID, tblCatagoryDetailPurchase.CatagoryID, tblCatagoryDetailPurchase.SubCatagoryID, tblCatagoryDetailPurchase.Cost, tblCatagoryDetailPurchase.Travel, tblCatagoryDetailPurchase.SubCatagoryName, tblCatagoryDetailPurchase.TransactionID, tblCatagoryDetailPurchase.TransDate
FROM tblCatagoryDetailPurchase LEFT JOIN tblCatagoryDetail ON tblCatagoryDetailPurchase.[CatagoryDetailPurchaseID] = tblCatagoryDetail.TableID;
Thanks
Dave