Retrieve records that contain the current date using a query

The current date is the system date Microsoft Access takes from your computer's system clock.

1. In query Design view, create a query. Add the tables whose records you want to use, and then add the fields you want to include in the results to the query design grid.
   
   
2. In the Criteria cell of the appropriate field, type Date(), with no space between the parentheses. For example, you can find all orders that were shipped on the current date by typing Date() in the ShipDate field.