Quantunet.com
Access QuickSkills
How to create a Query with a Date filter ?
Create a Query to search and collect results from the table:
Click on the Queries icon.
Select "Create query in design view" by double clicking.
Select the "Alumnos" table and pres the "Add" then "Close" button.
Scroll down the Alumnos window, select "NombreAlumno" and drag into the First field.
Select "NombrePadre" and drag into the Second field.
Select "NombreMadre" and drag into the Third field.
Select "FechaInscription" and drag into the fourth field.
Create specific Criteria to filter results:
In the FechaInscription column click on the "Criteria" cell then type: " > # 02/05/06 # ".
(This will find and show all the inscription entries marked with a date after May 2nd 2006).
View the resulting query:
Go to the main menu and press the view button.
Research syntax
© 2006 Quantunet.com All Rights Reserved Terms of Use
How to create a Query with a
Date filter ?
