467,885 Members | 1,269 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,885 developers. It's quick & easy.

Date Range in Form

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
  • viewed: 2899
Share:
1 Reply
PEB
Expert 1GB
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.

Similar topics

2 posts views Thread by androtech | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.