transfer parameter query to report label?

  • Thread starter Thread starter bill
  • Start date Start date
B

bill

How do I need to get the info gathered by a parameter query into a label on
a report? My parameter query is
Between[beginning date]and[Ending Date]. I would like this data "dates" to
show up at the top of the report. Thanks
Bill
 
Bill,
Add an unbound control to the report header.
Set it's control source to something like:
= "For Sales between " & [Beginning date] & " and " & [Ending Date]

The text within the brackets must be identical to the query bracketed text.
 
Put the following in the ControlSource of a text box:
=[Beginning Date] & " - " & [Ending Date]
(you can also put each date in a separate text box, but this usually looks
nicer)

If you spell them EXACTLY as you do in the query, the values will pass
through to the report.
 
Back
Top