Same Data from Multiple Tables

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

 

[Marshall Barton]

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?

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.