How To Print Selection Criteria On A Report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am new to Access and hence very inexperienced and so need a little guidance
please.
I have created a report which is accessed by users selecting the appropriate
command button from a form. The report is based upon a query, where the query
has selection criteria to enable the user to enter the 'Between' date range
used to select which records are to be printed.
I would like to print the selection criteria (i.e. the 'From' and 'To' dates
input by the user) on the report so that they can file the report knowing
which date range it covers.
Is this possible and if so then how?
Many thanks in anticipation,
Kind regards,
C.
 
How is the selection criteria entered? If you are prompting the user to
enter it, then add an unbound text box to your report with the same prompt.

If your query says...

Between [Enter Start Date] and [Enter Stop Date]

Then you could include an unbound text box in your report such as...

="This report includes items from " & [Enter Start Date] & " through " &
[Enter Stop Date]

As long as the entries are identical, the user will only be asked to enter
them one time and the entries will be used in both places.
 
Thankyou :-)

Rick B said:
How is the selection criteria entered? If you are prompting the user to
enter it, then add an unbound text box to your report with the same prompt.

If your query says...

Between [Enter Start Date] and [Enter Stop Date]

Then you could include an unbound text box in your report such as...

="This report includes items from " & [Enter Start Date] & " through " &
[Enter Stop Date]

As long as the entries are identical, the user will only be asked to enter
them one time and the entries will be used in both places.



--
Rick B



C. Stanton said:
I am new to Access and hence very inexperienced and so need a little
guidance
please.
I have created a report which is accessed by users selecting the
appropriate
command button from a form. The report is based upon a query, where the
query
has selection criteria to enable the user to enter the 'Between' date
range
used to select which records are to be printed.
I would like to print the selection criteria (i.e. the 'From' and 'To'
dates
input by the user) on the report so that they can file the report knowing
which date range it covers.
Is this possible and if so then how?
Many thanks in anticipation,
Kind regards,
C.
Click to expand...
Click to expand...
 
Back
Top