how can I filter by date on my search form

  • Thread starter Thread starter Mike Saifie
  • Start date Start date
M

Mike Saifie

I want to filter by date on my form. I want to input the date range from to
TO: and search. what is the code I can use to write for filtring between
dates,
 
In your query add this as criteria for the date field.
Between [Forms]![YourFormName]![YourFromFieldName] And
[Forms]![YourFormName]![YourToFieldName]
 
Back
Top