Multiple reports in range date

[PhilT via AccessMonster.com]

I have multiple reports using the same range of start and end date weekly.
The date is display in a tab form to remind me the date range.

I like to print weekly multiple reports using these range of date. Can anyone
help me. Thanks.

 

[KARL DEWEY]

Create a form with two unbound textboxes to enter your dates.
Use the textboxes as criteria in the query for the reports like this --
[Forms]![YourFormName]![TextBox1] and
[Forms]![YourFormName]![TextBox2]
Before running the reports open the form, enter the dates, leave form open
as long as you are running the reports.

You can also use the textboxes in a calculated field to pass the information
to you reports.

 

[PhilT via AccessMonster.com]

Karl,

I have couple questions:

1. I am using tab form, do I need to include tab form name also.
2. Can I use this criteria in the macro expression condition because the same
query also use for someting else.

many thanks

Create a form with two unbound textboxes to enter your dates.
Use the textboxes as criteria in the query for the reports like this --
[Forms]![YourFormName]![TextBox1] and
[Forms]![YourFormName]![TextBox2]
Before running the reports open the form, enter the dates, leave form open
as long as you are running the reports.

You can also use the textboxes in a calculated field to pass the information
to you reports.

I have multiple reports using the same range of start and end date weekly.
The date is display in a tab form to remind me the date range.

I like to print weekly multiple reports using these range of date. Can anyone
help me. Thanks.

 

[KARL DEWEY]

1. I am using tab form,.....
I would think so - I do not use tabs.
No. Macro condition is whether the macro action will be executed, not
select records.

--
KARL DEWEY
Build a little - Test a little

Karl,

I have couple questions:

1. I am using tab form, do I need to include tab form name also.
2. Can I use this criteria in the macro expression condition because the same
query also use for someting else.

many thanks

Create a form with two unbound textboxes to enter your dates.
Use the textboxes as criteria in the query for the reports like this --
[Forms]![YourFormName]![TextBox1] and
[Forms]![YourFormName]![TextBox2]
Before running the reports open the form, enter the dates, leave form open
as long as you are running the reports.

You can also use the textboxes in a calculated field to pass the information
to you reports.

I have multiple reports using the same range of start and end date weekly.
The date is display in a tab form to remind me the date range.

I like to print weekly multiple reports using these range of date. Can anyone
help me. Thanks.