Every query that you run uses SQL behind the scenes. Understanding how SQL works can help you create better queries, and can make it easier for you to understand how to fix a query that is not …

This is one of a set of articles about Access SQL. This article describes how to write a WHERE clause, and uses examples to illustrate various techniques that you can use in a WHERE clause.

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

Use criteria in an Access query to find specific information from your desktop database.

To make a query in Access databases ask for criteria when you run it, create a parameter query. This allows you to use the same query over and over without having to constantly open it in Design view …

This is one of a set of articles about Access SQL. This article describes how to write a FROM clause, and uses examples to illustrate various techniques that you can use in a FROM clause.

You can nest this query inside of your main query by using a subquery. You can write a subquery in an expression or in a Structured Query Language (SQL) statement in SQL view.

A query is a set of instructions that you can use for working with data. You run a query to perform these instructions. In addition to returning results — which can be sorted, grouped, or filtered — a query …

ANSI-89 describes the traditional Access SQL syntax, which is the default for Access databases. The wildcard characters conform to the Microsoft Visual Basic® for Applications (VBA) specification, not …

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 also …