ms-access-course - Adding date range to a report / query

Resolved · Low Priority · Version Standard

Adding date range to a report / query

Myriam has attended:
Access Introduction course

by - delegate Myriam [2 posts] (2008 Jan 16 Wed, 15:10) Reply

Could you please tell me the best way to add a date range when requesting a report or reviewing a query. I want to be able to select the start date and end date and for the report/query to provide the data based on the parameters.

Kind regards

Myriam

Version	Date	Location	Places available	Book	Next place rate:
Access Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2007	2008 Dec 5 Fri	Bloomsbury	4	book now	£224	£224
2003	2008 Dec 9 Tue	Bloomsbury	0	FULL
2002/XP	2008 Dec 11 Thu	Tooting	0	FULL
2003	2008 Dec 18 Thu	Bloomsbury	2	book now	£215	£215
2003	2008 Dec 23 Tue	Bayswater	8	book now	£182	£207
2002/XP	2008 Dec 24 Wed	Tooting	0	FULL
Full Schedule: See all 52 Access Intermediate course dates. Bookings currently available until 24th November 2009.

RE: Adding date range to a report / query

by - trainer Stephen gold contributer [386 posts] (2008 Feb 9 Sat, 11:11) Reply

Hi Myriam

Thank you for your question.

If you open your query in design view and in the criteria row type the following

Between [Enter start date] and [Enter finish date]

The brackets must be the square ones.

This will then prompt you for a start and finish date when the query is run

Hope this does the trick

Regards

Stephen