microsoft-access-courses - Parameter query

Resolved · Low Priority · Version Standard

Thu 4 Oct 2007, 14:47 Delegate Karen said...

Karen has attended:
Access Consulting course

Parameter query

What is a parameter query?

Thu 4 Oct 2007, 15:03 Trainer Amanda said...

RE: Parameter query

Hi Karen

Thank you for your question.

A parameter query is a query that displays its own dialog box prompting you for information, such as criteria for retrieving records. You can design the query to prompt you for more than one piece of information; for example, you can design it to prompt you for two dates.

I hope this helps.
Amanda

Access tip:

Deleting duplicate records from a table

You cannot delete records tables where there duplicate records. A way around this is to create a new table which wont hold the duplicates. and then deleting the old table.

1. Use a make-table query based on this table only. IMPORTANT - Ensure that you include all of the fields from your original table or you may loose data.

2. Open the query's property sheet by using VIEW, QUERY, PROPERTIES, and set the Unique Values property to Yes

3. Because you have selected the Unique Values to Yes when you run the query, Access creates a new table without duplicate records. You can now delete the old table and rename the new one.

View all Access hints and tips

microsoft-access-courses - Parameter query

Parameter query

RE: Parameter query

Access articles

Access tip:

Deleting duplicate records from a table