Between Dates

  • Thread starter Thread starter Dorothy
  • Start date Start date
D

Dorothy

I have a report that when clicked on the user is asked to
specify the beginning date and ending date that
applications were received. I would like these dates to
appear on the report as part of the heading,
i.e., "Applications Received Between 1/1/04 and 5/1/04."
The qry the report comes from has the DateRecd field and
in the criteria of the date field it has "Between
[BeginningDate] And [EndingDate]" Any help is greatly
appreciated.
 
Add a text box with a control source of:
="Between " & [BeginningDate] & " And " & [EndingDate]
 
Thanks Duane, that worked.
-----Original Message-----
Add a text box with a control source of:
="Between " & [BeginningDate] & " And " & [EndingDate]

--
Duane Hookom
MS Access MVP


I have a report that when clicked on the user is asked to
specify the beginning date and ending date that
applications were received. I would like these dates to
appear on the report as part of the heading,
i.e., "Applications Received Between 1/1/04 and 5/1/04."
The qry the report comes from has the DateRecd field and
in the criteria of the date field it has "Between
[BeginningDate] And [EndingDate]" Any help is greatly
appreciated.
Click to expand...


.
Click to expand...
 
Back
Top