Running Reports

[Mike]

When I run a report, is there a way to use the "Microsoft Date and Time
Picker Control, Version 6"? To Pick My start and ending date for the report

I have a Expense Report That I need to Pull Between Dates

Any help would be GREAT

 

[Allen Browne]

It is possible to include a reference to this control, and use it on a form
where you build the WhereClause for OpenReport based on the values in the
control.

However, there are several issues with this control, e.g.:
- problems with refrences;
- problems with international dates;
- problems with nulls.

IMHO, you would be better off using this one from Stephen Lebans:
http://www.lebans.com/monthcalendar.htm
or a simple little Access form like this:
http://allenbrowne.com/ser-51.html
or one of the many others available:
http://www.granite.ab.ca/access/calendars.htm