OK, I am pulling my hair out on this one. It seems like it should be so simple and I cannot seem to find the answer.
I am using Access 2000 on Windows 2000.
I have two tables set up. Table One is updated Daily, Table Two is going to keep a running tally of Data.
What I need to do is add records form Table One into Table Two. However, I only want to add records that do not exist.
Here is the tricky part. The data in Table One is not identical to Table Two. I need to have it look at 6 columns in Table One and the same in Table Two. If they are Different (all six fields) then Add the record to Table Two.
I cannot find the correct sequence to write to make this happen.
I have tried playing with a regular query to show me the records that do not match(non-duplicate). I can have it show me all files that do, but cannot figure out how to show records that do not match.
The Matching fields are all text fields. Some have numbers, but because of the information they need to saved as text.
Any help is greatly appreciated. Any questions about the information please do not hesitate to ask. Thank you in advance for your help.
Nick