Date Ranges

[carpstar]

I Have a report with a query as record source.
Report parameters are by date range set in criteria of query 'Between[Enter start date] And [Enter end date]'. Question, how can I get the date range user enters at parameter prompts to appear on the report.
I'm new to Access, Can someone please help.

[This message has been edited by carpstar (edited 04-05-2002).]

[This message has been edited by carpstar (edited 04-06-2002).]

[This message has been edited by carpstar (edited 04-06-2002).]

 

[Sohaila Taravati]

This is how you do it in the query:
Between [Enter Beginning Date:] And [Enter Ending Date]
I hope this is what you wanted!

Sohaila

 

[Sohaila Taravati]

If you want it to appear on your report, this is how you do it:
You have to put this in a control source of a text Box

=Format([Enter Begining Date:],"mm/dd/yy") & " through " & Format([Enter Ending Date:],"mm/dd/yy")

Sohaila