Hi. First, I am using WIN XP and Access 2003.
I have a table with 60,000 records. Each week I import a delimited file with all records plus the new records that were added. Right now we can't distinguish the new records from the ones already there, so I use a delete query to delete all recs in the table and just import everything again.
One field is named CaseNumber and one DateEntered. There will never be a duplicate CaseNumber. So, if I run a query with CaseNumber and DateEntered using 9-20-04 as criteria, then next week I run the same query using the same date, how can I exclude the CaseNumbers that it already pulled this week? Is there a way to "tag" the records or something?
I have a table with 60,000 records. Each week I import a delimited file with all records plus the new records that were added. Right now we can't distinguish the new records from the ones already there, so I use a delete query to delete all recs in the table and just import everything again.
One field is named CaseNumber and one DateEntered. There will never be a duplicate CaseNumber. So, if I run a query with CaseNumber and DateEntered using 9-20-04 as criteria, then next week I run the same query using the same date, how can I exclude the CaseNumbers that it already pulled this week? Is there a way to "tag" the records or something?
