Running a Query from a Form

[Rhett_Y]

Hello all..

Is this possible...

I would like to create a form that will run a query.. It is a datequery.
I would like to have two calenders displayed, the person can pick the in
between days IE: jan 1st 2005 on the first calendar then on the second
calendar they pick: july 4th 2005 then hit the run query command it and gives
you the information in a report... Is this possible... I don't like having
to enter the dates manually, because the person doing the query might not
know how to properly enter the date.. I would really like to give the option
of a calendar etc....

Thanks
R~

 

[JimS]

I think you can do this by using two datepickers, then setting the form's
..recordsource property to a sql statement you build using those two dates. It
would take me too long to do the code, but it seems straightforward to me. Of
course, requery the form before ending the control event procedure....