Parmeter Display

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

Guest

I have a parmater query thta asks for the ending date in a range. I uses between 11/1/2003 and the parameter value. I want to be able to display only the parameter date on the report.
 
George said:
I have a parmater query thta asks for the ending date in a range. I
uses between 11/1/2003 and the parameter value. I want to be able to
display only the parameter date on the report.
Click to expand...
George,
If the parameter is written in the query as:
Between #11/1/2003# and [End Date]

Add an unbound control to the report header.
Set it's Control Source to:
= "For sales from 11/1/2003 and " & [End Date]

The text within the brackets must be identical to the query bracketed
text.
 
Back
Top