how can I filter by date on my search form

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,
 
K

KARL DEWEY

In your query add this as criteria for the date field.
Between [Forms]![YourFormName]![YourFromFieldName] And
[Forms]![YourFormName]![YourToFieldName]
 
Top