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

[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

 

[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.

 

[Joseph Meehan]

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

I suggest adding a binary field and printing only those with the field
set to the default. Then have an update query ready to set all the records
to the non-default setting. Trigger that update query by an even that you
know will only take place after the report is run (an accepted?).

The other suggestion would be date based, but you can run into some more
complex issues there.

 

[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

 

[Joseph Meehan]

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

No need for two tables. Normally good procedure is to leave all the
data in a single table.

Note: The Access date field is a Date & Time field in one. You could
(although I don't suggest it) still use it.

I would stick with my original suggestion with a single binary filed.
You can call it "Archive" if you like.