Date Label on Top of report

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

Guest

Hello,

I have a report that needs a from date and a to date (10/1/2004 to
10/7/2004).I have this report from a parameter query that requires you to
enter these two dates but it does not show up on the report.How can i place
these dates on the report?
Thanks
 
One way to do this is to use a form to "gather" your parameters, modify the
query to look to the form for the criteria (using something like:
Forms!YourForm!YourControl), and base your report on this query.

Then, in the report, you can create a text field that uses something like
the following for a control source:

= "From " & Forms!YourForm!YourFromDate & " to " &
Forms!YourForm!YourToDate
 
JK,
Lets say you used 2 parameters in your query to get 2 dates from the
user...
[Enter Start Date] and [EnterEnd Date]
Placing a text control on your report with...
= "From " & [Enter Start Date] & " to " & [Enter End Date]
would display as...
"From 1/1/04 to 2/1/04"
Those parameters can be used just like a bound field on your report.
hth
Al Camp
 
Back
Top