Parameter dates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date Range Query 6
ranking two reports 1
Extract user input from query into report 7
IIF question 3
Query - counts per week? 2
SQL Query between 2 dates 5
Problem with Date Query 6
checking multiple fields for a requested date 1

Back
Top