Query based om data from two calendar

[Guest]

Hi
I have a query with a date field
Now i have made a form with two calendar inside
name Startdate and Enddate.

How can i make the query so it see what i have click on
in the two calendare. I want to run the query from Startdate to Enddate

Regards
alvin

 

[[MVP] S.Clark]

Most objects have a .value property that can be retrieve with VBA.

sql = "Select * from tablename WHERE MyDate Between #" & objCal_Start.value
& "# And #" & objCal_End.value & "#"

--
Steve Clark, Access MVP
FMS, Inc
http://www.fmsinc.com/consulting
Professional Access Database Repair
*FREE* Access Tips: http://www.fmsinc.com/free/tips.html