advanced access queries

Public Schedule Face-to-Face & Virtual Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Access Training and help » Advanced Access Queries

Advanced Access Queries

resolvedResolved · Urgent Priority · Version 2007

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!

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.


 

Access tip:

Change case

To change case from upper or lower case, highlight the text area, hold down the Shift key and pres F3

View all Access hints and tips


Server loaded in 0.07 secs.