Design or modify a query

In query Design view, you can do any of the following procedures to complete the design of a new query you just created or modify an existing query. You can also use these procedures to modify an SQL statement that's the source of records for a form, report, or data access page. Changes you make in query Design view are reflected in the SQL statement.

If you're designing or modifying queries in a multiuser environment, there are certain things you should consider. For more information, click .

What do you want to do?

Work with a table or a query in a query

Add a table or query

Remove a table or query

Work with joins

Join multiple tables

Change the type of join between two tables

Delete a join between two tables

Work with fields

Add a field

Remove a field

Move a field

Insert a field between other fields

Change a field name

Show or hide a field in the query's results

Set properties

Work in the query design grid

Change column widths

Clear the design grid

Add a column to the design grid in a query

Set criteria or a sort order

Insert or delete a criteria row

Set or change criteria

Specify a sort order for the result set

Perform calculations on data

Work with SQL in a query

Modify the SQL statement directly