I am really knew to Access so my apologies if this is covered already.
Every month I get a download in Excel and I save that download in the same location every time and overwrite the existing Excel file. That file is a linked table in Access which I created a query from. That query has 15 fields and I take that query and run an append query that appends that data to a Master table called STATE RECON TABLE. My Master table has 16 fields and 15 of which are the exact same fields in the query and the last field is a reconciling field. So this Master table that I have a use to reconcile against another set of data and each time I reconcile a record in the Master Table I put the word RECON in that 16th field. Next month when I get a new download I will go through this same process, however when I run the append query this time I would like the append query to only bring in new records. I have no specific field and I am not entirely sure how an append query works but the append query would have to identify duplicates based on the entire record and not just one key field. not really sure how I get from point A to point B. below is my append query
Code:
INSERT INTO [STATE RECON TABLE] ( [Index], Fund, [Fund Code], Orgn, [Unit Code], Acct, GL_Type, [TRANS DATE], TYPE, DOCUMENT, DESCRIPTION, [DOC REF], FLD, AMOUNT, Division )
SELECT ORIG_STATE_DL_QRY.Index, ORIG_STATE_DL_QRY.Fund, ORIG_STATE_DL_QRY.[Fund Code], ORIG_STATE_DL_QRY.Orgn, ORIG_STATE_DL_QRY.Unit_Code, ORIG_STATE_DL_QRY.Acct, ORIG_STATE_DL_QRY.GL_Type, ORIG_STATE_DL_QRY.[TRANS DATE], ORIG_STATE_DL_QRY.TYPE, ORIG_STATE_DL_QRY.DOCUMENT, ORIG_STATE_DL_QRY.DESCRIPTION, ORIG_STATE_DL_QRY.[DOC REF], ORIG_STATE_DL_QRY.FLD, ORIG_STATE_DL_QRY.AMOUNT, ORIG_STATE_DL_QRY.Division
FROM ORIG_STATE_DL_QRY;