Printing Query Promt Parameters in a report

  • Thread starter Thread starter vegman
  • Start date Start date
V

vegman

I have a QUERY in Access 2003 that promts the user for a START and END date.
Is there a way to display the inputed START and END date from the QUERY in a
REPORT without having to retype it in the report?
 
I have a QUERY in Access 2003 that promts the user for a START and END date.
Is there a way to display the inputed START and END date from the QUERY in a
REPORT without having to retype it in the report?
Click to expand...

Let's assume the exact query prompt is [Start Date] and [End Date]

Add an unbound text control to the Report Header.
Set it's control source to:
="For Sales between " & [Start Date] & " and " & [End Date]

The above text within the brackets must be identical to the bracketed
text in the query.
 
Another way is to add them as a 'calculated' field. In design view grid
blank in FIELD row copy and paste parameter to look like this --
Parm1: [Start Date]
Parm2: [End Date]
or
Pram1: "For Sales between " & [Start Date] & " and " & [End Date]

Use Parm1 and Parm2 or the second Parm1 in your report.

--
Build a little, test a little.


fredg said:
I have a QUERY in Access 2003 that promts the user for a START and END date.
Is there a way to display the inputed START and END date from the QUERY in a
REPORT without having to retype it in the report?
Click to expand...

Let's assume the exact query prompt is [Start Date] and [End Date]

Add an unbound text control to the Report Header.
Set it's control source to:
="For Sales between " & [Start Date] & " and " & [End Date]

The above text within the brackets must be identical to the bracketed
text in the query.

--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
.
Click to expand...
 
Back
Top