Same Data from Multiple Tables

  • Thread starter Thread starter Racer57
  • Start date Start date
R

Racer57

I have two identical tables - one for Wilmington and one for Newport. I need
to print a report from each table that contains the same info for a specific
date range.

How can I enter the Start and End date once, and have both reports print the
data for that range?
 
Racer57 said:
I have two identical tables - one for Wilmington and one for Newport. I need
to print a report from each table that contains the same info for a specific
date range.

How can I enter the Start and End date once, and have both reports print the
data for that range?
Click to expand...

Use a form with text boxes for the users to enter the dates
and command buttons to print the reports. Look at the VBA
code for the command button's Click event and use the
OpenReport method's WhereCondition argument to specify the
date range. For details, look at my reply to yesterday's
question from BobC.
 
Back
Top