transfer parameter query to report label?

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
 
F

Fredg

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.
 
R

Roger Carlson

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

Top