How do I display Criteria results on reports

[Eyal]

My problem is as follows. In my criteria I used the between/and option to
enter dates. In my second criteria I entered a second between/and option to
enter different style numbers.
I would like to show both results of both criteria on my report. How can I
do this?

 

[Allen Browne]

How are these criteria entered?

If you have a parameter in the Criteria row in a query, you can refer to
that in your report. For example, if the criteria is:

= [StartDate]

then you can put a text box on your report, with Control Source of:
=[StartDate]

Similarly, if you have criteria of:
[Forms].[Form1].[txtStartDate]
you can put a text box on your report, with Control Source of:
=[Forms].[Form1].[txtStartDate]
assuming that the form stays open.

In Access 2002 or later, another possibility is to pass a description of the
criteria to the report in its OpenArgs when you OpenReport, and then use a
text box with ControlSource of:
=[Report].[OpenArgs]
(The expression is just that, regardless of the name of your report.)

More detail in:
Limiting a Report to a Date Range
at:
http://allenbrowne.com/casu-08.html