Date Serial

[mark curtis]

Dear all,

I have a long request and would appreciate any help:

Scenario:
My Manager wants me to create a report where he can specify a start and end date to run the report from. I know that this can be done with a parameter query, prompting for input twice But I want to let my Manager select a date via a calander form, which has a start date and end date. A user will click on the start date calander thus selecting year, month and day then do the same for end date. I know that I can use two invisible text fields to hold the dates but I am having problems understanding the principals (syntax)for DateSerial, which would be used as follows in my query:

Between DateSerial Start date(year/month/day) and End date(year/month/day)

Any help or examples where the above may have been used would be much appreciated.

I could always send you the form and a query.

Thanks
Mark

 

[Neal]

You should be able to do that by using this in the query:
Between forms!yourform![txtboxStart] and forms!yourform![txtBoxEnd].
I am curious how you populate those text boxes from a single calendar control. I though selecting a date would only return one value. If you select a second, it overwrites the first.


[This message has been edited by Neal (edited 12-21-2000).]

 

[Jack Cowley]

Neal -

You can populate more than one text box with the calendar control. I have a small demo the uses the calendar to put dates into two text boxes. If you are interested just send me an email and I will send it to you. It is in Access97....