capture Between..And Parameter dates into Report

  • Thread starter Thread starter Cal Miyatake
  • Start date Start date
C

Cal Miyatake

I have a Between...And parameter query that i use to
create a report. In the Header of the report I have a
Text Field that has " From: To: ". I would
like the Between....And...Date parameter information
placed in the From:..... To:....... area. How can I do
that?
 
Enter this in your text box (Include the quotes!):
="Report from " & [Start Date] & " " & "through" & " " &
[End Date]

HTH

Denny G.
 
One more thing: Be sure to use the words [Start Date]
and [End Date] as your date parameters in the Date column
of your query in order for my previous example to work.

Denny G.
 
Back
Top