How to Create an Access Date Query

Create an Access date query by using the Date fields in the query. The query can include criteria to further refine the date query. The date must be surrounded with "#" symbols so Access can properly query the date. When creating the Access date query, use the Query Design feature on the ribbon to add the fields that you want displayed in your date query. In the criteria field, add a date, then run the date query to see the results.

Instructions

1. Open Access 2010, click the "File" menu and select "Open." Browse your files and locate the database. Click the database and select the "Open" button.

2. Click the "Create" tab and select "Query Design." The Show Table Dialog box appears. Click a table from the Show Table dialog box. Click the "Close" icon to close the Show Table dialog box.

3. Add fields to the date query by double-clicking the field names in the table field. Add an exact date to the "Criteria" field of the date field. For example, if you are looking for invoices that were processed on June 1, 2010, enter the date of "#6/1/10#." Notice you enclose the date with "#" symbols.

4. Run the query by clicking the "Run" icon. Review the results of the date query.

References

• Microsoft: Examples of Query Criteria

Resources

• Microsoft: Access How To & Help