How to Query Time in Access

Save

Query time in Access by using time fields and criteria in the Query Design view. When querying time and date fields, the criteria must be enclosed with pound symbols. Once the proper format is utilized in the design view, execute the query to see the results in the Datasheet view. The query can be created by using the Query Design option on the ribbon. This option gives you complete control over what fields, tables and queries are used in the time query.

  • Open Access 2010, click the "File" tab and select a database from the list of recently used database in the File menu. The database opens.

  • Click the "Create" tab and select "Query Design." The Show Table dialog box opens. Add tables to the dialog box by clicking the "Add" button. Close the Show Table dialog box by clicking the "Close" button.

  • Add fields to the query by clicking the field name and dragging the field to the query. Add a field that is formatted specifically for time. To make sure the field is formatted properly select the field and "Property Sheet" button on the ribbon. Verify the time format in the "Format" field.

  • Add a criteria in the time field. If you want to see all invoices processed after 8:00 a.m., enter the following criteria: ">#8:00:00 AM#." Use the ">" symbol to indicate items after 8:00 am.

  • Run the query by clicking the "Run" icon on the ribbon. Review the results of the time query in the datasheet view.

References

Promoted By Zergnet

Comments

Resources

Related Searches

Check It Out

Geek Vs Geek: Robot battles, hoverboard drag race, and more

M
Is DIY in your DNA? Become part of our maker community.
Submit Your Work!