On Tue, 23 Mar 2010 15:46:01 -0700, daisy
wrote:

Hi, I am trying to create an access database that has historical data and new
data is imported in monthly. I need it to be able to check each time if it's
a new member before it dumps into the data. If it's new it needs to be
tagged new? And then I need to be be able to run comparisons on future data
to that first event? What's the best way to clone the records together?

1) Do I create a working table (holds everything)
2) Create a temp table (monthly table)
3) Somehow run something that checks and tags? How do I do this?
4) Then append?

Depends. What are you importing *from*? A text file, a spreadsheet, another
Access database table, something else? What constitutes a "new" record? Do you
have a unique primary key in your table? in the import? If a record has an
identical unique key but different data, do you want to overwrite the existing
data, add a new record, generate a warning, or what?

More info please!
--

John W. Vinson [MVP]