By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,660 Members | 1,557 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,660 IT Pros & Developers. It's quick & easy.

Date Range in Form

P: 44
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.
Sep 15 '06 #1
Share this Question
Share on Google+
1 Reply


PEB
Expert 100+
P: 1,418
PEB
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.
Sep 16 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.