microsoft-access-course - Msoft access intermediate

Resolved · Low Priority · Version Standard

Tue 27 Nov 2007, 17:34 Delegate Richard said...

Richard has attended:
Access Intermediate course

Msoft access intermediate

please explain where i can find more examples on cross tables

Thu 29 Nov 2007, 16:35 Trainer Amanda said...

RE: msoft access intermediate

Hi Richard

Thank you for your question.

There is a lot available on the internet, but here are a couple of links that you might find useful:

1. This gives an explanation and there is an example, which can be downloaded in pdf format:
http://articles.techrepublic.com.com/5100-10877_11-6121381.html

2. An article from the databasedev web site which I find quite useful - quite a bit of detail:
http://www.databasedev.co.uk/crosstab_queries.html

I hope you find these useful.
Amanda

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Access tip:

How To Find All Overdue Accounts?

To find overdue accounts create a filter that compares today's date with the Invoice Date in the table. To do this:

1. Open the Query in Design View
2. Select the field for the filter and in the criteria row enter:

<Date()

This filter returns records where the Invoice Date is before today's date.

This filter can be manipulated if, for instance, Invoices are due 15 days after the Invoice Date. For this the filter would be:

<Date()-15

This filter returns records where the Invoice Date is 15 days before today's date.

View all Access hints and tips