How Do I get a report to print ORIGINAL / REPRINT

  • Thread starter Thread starter Thara Robertson
  • Start date Start date
T

Thara Robertson

I need to set up my report so that it prints on it that
this is the first time the report has been printed. After
it has been printed the first time it needs to say REPRINT
for subsequent prints and if the data has been altered it
needs to indicate SUPPLEMENT.

Is there a way in access to do this?
 
You would need to create a table to store this information. When the report
is opened, you would need to write a record to the table. You could then
test the table to determine what to print.

That is the basics.

When you say original, do you mean the first time ever, first time that day,
first time that week?

When you say supplement, do you mean if any piece of data on the report
changes? Do you currently have some type of timestamp field in your records
that records the data and time a record was changed? You would need one
that you could compare with the date the report was previously run (stored
in our new table).

Hopefully this will get you thinking and on the right track. If you need
specific detailed help, ask for the specifics.

Someone out there may know of a sample database on the net with this type of
logic. Hopefully they will respond and share that with you.

HTH
Rick B

I need to set up my report so that it prints on it that
this is the first time the report has been printed. After
it has been printed the first time it needs to say REPRINT
for subsequent prints and if the data has been altered it
needs to indicate SUPPLEMENT.

Is there a way in access to do this?
 
Back
Top