Update report

  • Thread starter Thread starter Tracy
  • Start date Start date
T

Tracy

I want to create a report that someone else will be
generating that lists only the records in the table that
have been created since the last report was run. For
example, I ran a report on August 27 and I would like to
generate another report today that lists only the records
that have been created since that date. Is it possible to
create a report that requests a parameter that the user
can enter as opposed to changing the report query each
time the report is run?
 
yes. my guess would be to add a column to the table called 'printdate',
include a where clause and a parameter of printdate in your query and update
the code w/i the report to insert todays date into the printdate column via
a recordset. i'm sure someone will provide a better solution but at least i
tried.
-rob
 
Rob,
Thanks. I will try this method.
Tracy
-----Original Message-----
yes. my guess would be to add a column to the table called 'printdate',
include a where clause and a parameter of printdate in your query and update
the code w/i the report to insert todays date into the printdate column via
a recordset. i'm sure someone will provide a better solution but at least i
tried.
-rob



.
Click to expand...
 
Back
Top