Access: Get the date - how it works

With Microsoft Access, you can easily query your tables for the date. You can find out how to do this in this practical tip.

Query the date with Microsoft Access

1. First create a simple query with the tables you are interested in.
2. A field with a date must be below the fields that you want to display later.
3. To narrow down the date, you can now define various criteria under the field with the date.
4. With the criterion "Date ()" you only get entries with today's date or with "
5. You can also simply enter the desired date in the format "01/01/2016" to only receive entries with this date