How can I send a report that only includes the items that are new?

M

Michael

I need to make a process that exports the files to another computer that
have not been already processed. I remember that I did it before and used a
query to make a new recordset and destroy the old recordset, but do not
remember how it was done.

thank you
Michael
 
R

Rick B

Exports "files" or records?

Do you include a date in your records?

If so, use the date in your query to pull all records where the date is
greater than X.
 
M

Michael

Thanks guys, the problem with using date is that I need to grab the info a
few times a day.
I have gotten most of it out of the cobwebs in my brain and have done the
following but not there yet

I have the form that puts the info in the "data" table.
Then I have a update query that puts a copy in the "archive"file.
I need to export the data and I am working on that,
then I have a delete file that will clear the "data" file after I export the
info.

this way each time I do a export I will have a copy in the archive and a
empty table so anything that comes in will not have been processed.

Now I just don't remember how to write a macro that exports the date in a
basic format that can be used by another program like a txt. or a cvs file.
thanks again for your help
Michael
 
Top