access-database-training - Create action query

Resolved · Low Priority · Version Standard

Sat 16 Dec 2006, 11:27 Delegate Janice said...

Janice has attended:
Access Introduction course
Access Intermediate course

Create action query

How do you create an action query?

Mon 18 Dec 2006, 15:29 Trainer Andrew said...

RE: Create action query

Hi Janice

Thanks for your question - one way to create an action query is to first build your query as a regular Select Query. Once you are happy that the query is returning the correct records you can then change it to the Action Query type you require.

To do this switch to design view and select the appropriate action query (such as update, append or delete) from the Query menu.

Hope this helps - do let us know if you have any further questions.

Thanks

Andrew

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