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 » Queries

	98.1 % recommend us
	More live stats...

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

Training information:

Queries

Resolved · Low Priority · Version 2003

Reply Thu 18 Dec 2008, 15:10Delegate Matt said...

Matt has attended:
Access Introduction course

Queries

How do I create a crosstab query?

For upcoming training course dates see: Pricing & availability

Reply Mon 5 Jan 2009, 10:44Trainer Stephen said...

RE: Queries

Hi Mat

Thank you for your question

Open the query designer and select the tables and fields that you wish to show

Then click on the query type button on the toolbar and select CrossTab. This will add a cross tab row into the designer and you can then specify the row and column headings together with the data field. You will need to specify the function type for the datafield in the group by row of that field.

Regards

Stephen

Mon 12 Jan 2009: Automatically marked as resolved.

Access articles

· How To Filter And Sort Data In Access 2010 Tables
· Cheating With Access Templates
· What You Need To Know About New Security Features In Access 2007
· It's so easy to Access the information you need
· The Benefits of Certified Microsoft Training in Access

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

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