Hi,
I use Between [Date1] And [Date2] in my query. It works fine. The users will
enter the dates in the message boxes. Is there a way to insert the calendar
on these message boxes so they can click on the calendar instead of entering?
Form? or Report?
Please help.
Thanks
Chi
Klatuu - 13 Nov 2007 19:25 GMT
Not the way you are doing it.
You would have to create two controls on a form. The controls can be
calendar controls. Then your query should reference the controls on the form:
Between [Forms]![MyForm]![Date1] And [Forms]![MyForm]![Date2]

Signature
Dave Hargis, Microsoft Access MVP
> Hi,
>
[quoted text clipped - 6 lines]
> Thanks
> Chi