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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top