Parameter Query of "between ...and "

  • Thread starter Thread starter Pearl
  • Start date Start date
P

Pearl

I have a parameter query that asks for begin date and end date. I'd like
these dates to be revealed in the report associated with this query. How can
I do that?
 
You can set a control's source to the name of a parameter just as if it were a
field. You must get the "name" exactly the same as the parameter including
spaces.

For instance if the parameters are [Begin Date] and [End Date]
You can combine them if you wish

Control Source: = "Date Between " & [Begin Date] & " and " & [End Date]

If you want the dates formatted, use the format function to specify the date
format.

Format([Begin Date],"mmmm d, yyyy")
will display September 1, 2009 if your input was that date.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
 
Back
Top