You can either create a query from imported data or create a blank query. You may want to just start from scratch. There are two ways to do this. At this point, you can manually add steps …

Choose whether you want to open the query in Datasheet view or modify the query in Design view, and then select Finish. For more info, see Get started with queries or Create a simple …

Using a parameter in a query is as easy as creating a query that uses criteria. You can design a query to prompt you for one piece of information, such as a part number, or for more than one …

Queries help retrieve information from your Access database. Here's how to create a simple select query.

The Like criteria or operator is used in an Access query to find data that matches a specific pattern. For example, in a sample database, we have a "Customers" table, like the one below, …

When you create a query, you can override this behavior so that the bound value is shown instead. In this example, suppose you want to see the bound value of a Lookup field in a …

Convert your bottom values query (or your Min totals query) into an append query and run this query to append the records to your top values table. The steps in these sections explain how …

If the box is blank, you can select an existing table or query as the record source, or you can create a new query to serve as the record source. If the box contains a SELECT statement, …

This article explains how to count the data returned by a query in Access. For example, on a form or report, you can count the number of items in one or more table fields or controls. You can …

When you want to either quickly delete a lot of data or delete a set of data on a regular basis in an Access desktop database, a delete or an update query might be useful because the queries …