Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Advanced Access Queries

Resolved · Urgent Priority · Version 2007

Reply 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!

For upcoming training course dates see: Pricing & availability

Reply 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.

Access articles

· An Essential Guide To Using The Northwind Database In Access 2010
· Learn About Action Queries In Access
· How Access Can Provide The Key To Successful Stock Management
· How To Resolve Access Data That Gives You Déjà Vu
· How Do Cross Tabs And Pivot Tables Differ In Microsoft Access?

Please browse our web site to find out more about
microsoft access training london and other Microsoft training courses.

Access tip:

Run with the total

Often when creating reports with lists of transactions it can be useful to have a column which totals the transactions as the report progresses.

Using the Sum function gives the total for the whole group, not a running total.

Access provides an easy method of achieving a running total.

Click on the text box containing the data you wish to contain the running total.
Select the Data tab
Click in the Running sum option
Click the down arrow to view three options

View all Access hints and tips