98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access Training and help » ms-access-course - Adding date range to a report / query
ms-access-course - Adding date range to a report / query
Resolved · Low Priority · Version Standard
Wed 16 Jan 2008, 15:10Delegate Myriam said...
Myriam has attended:
Access Introduction course
Adding date range to a report / query
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
Sat 9 Feb 2008, 11:11Trainer Stephen said...
RE: Adding date range to a report / query
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
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Hide Access TablesOne method of stopping your Access tables appearing in Database window, is to rename the table(s) with the prefix usys. |
