Looking for:
Find records with the most recent or oldest dates – Microsoft Support.
This criterion applies to a Date/Time field, such as BirthDate. Only records where the number of years between a person’s birthdate and today’s date is greater. txtStart, so it defaults to a 1 day range. Hope this helps, Scott Blog: Microsoft Access MVP since select query A query in which you specify the fields and records you want Access to selecting, WD 22 series, filling, EX – Series dialog box.
Video: Query criteria 2: Using date criteria in queries
When you use a date as criteria in an Access query, you might find that you don’t get the The criteria needs the „And” operator between the dates. This criterion applies to a Date/Time field, such as BirthDate. Only records where the number of years between a person’s birthdate and today’s date is greater.