Hi,
In your query type instaed:
between #01/07/2006# and #31/07/2006#
the following:
between CVDATE(Forms![Your Search Form]![Start]) and CVDATE(Forms![Your Search Form]![End])
:)
Hi,
I want to create a from where user can select from a date range / type in a date range to get only data from an underlying query within this range.
This should overwrite the existing criteria in the query regarding the date.
Example:
I have 3 new staff member in month August. The last time user wanted output from the staff table was for month July. So the criteria for the Appointment Date in my query was set "between #01/07/2006# and #31/07/2006#". Now the month August should be checked and the user should input the new date range in a form.
How can I get that into a form and updating the criteria of a query to result the new output?
Thanks a lot for your help.