Filter by date

[adsm]

Hi anyone,

How could I filter the data sheet in the customers list from the attached database when the user writes the beginning date in the first text box and the end date in the second text box.

Any help on this would be kindly appreciated.

Thanks in advance.



Best Regards
adsm

[maximus]

In the query in he criteria of the the date Field use this expression:

Between [Forms]![FormName]![Name of the Begining Date TextBox] And [Forms]![FormName]![Name of the Ending Date TextBox]

Note: Make sure that the TextBox(s) Data Format is Set to Date format of the Date field in the query

[adsm]

Thanks for the help maximus. I do really appreciate your help.

[maximus]

Please mark this thread solved