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 » Advanced Access Queries
Advanced Access Queries
Resolved · Urgent Priority · Version 2007
Fri 8 Jul 2011, 17:08Delegate Daniel said...
Daniel has attended:
Access Advanced course
Advanced Access Queries
Date Functions
Allow user to enter or select an ingredient by ingredientDescription and the system will produce a list of all patients who have had a dish including that ingredient on a menu for them with a service Time later than 31days before the current date and time.
what I want is how to work out Service Time later than 31 days before the current date tim Please!
Mon 11 Jul 2011, 09:39Trainer Stephen said...
RE: Advanced Access Queries
Hi Daniel
Thanks for your question
This is fairly straightforward.
In the query designer simply enter the following criteria for your service Time field
>(Date()-31)
This will return every date that is 31 days or less from the system date
Hope this is useful
Regards
Stephen
Sun 17 Jul 2011: Automatically marked as resolved.
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:Change caseTo change case from upper or lower case, highlight the text area, hold down the Shift key and pres F3 |
