Access Date and Time Picker

[jsimard]

Right now my query asks the user to input a start date and end date. Can the Date and Time picker calendar be used for this instead of the user having to type in the date? I have a report generated from this query as well. Could it be used for the report?

[imintrouble]

So let me get this straight, you want the user to be able to have it where when they click into the start date field, they may click on the actual start date. For the start and end date both?

Well if this is the case then what you will have to do is, in the original table which the query is made from, make the fields which will hold the start and end date data into a date & time coulmn. To do this, go to the original table and go as far right as the window will allow, then look for where it says Click to Add. click the down arrow and then click the date & time option. this new column you created will include a mini calendar which the user may click the date they want to have as the start date. Do this again for the end date.

Hope this helped.