I need a form in MS Access 2000 that will allow a user to select a beginning date and an end date. Those dates will serve as the criteria for a query from which a report will be launched. In other words, the dates are passed to a query, and there is a report that will show up based on the results from that query. I need a fairly open structure that I can massage into the final product I'm looking for but I can't personally program the Access VB from scratch. I will provide a database containing a table with sample data, the basic query, and a basic report. Your job is to create a simple form with a MS calendar control to let the user pick a start and end date, along with a button to preview the report containing the selected data based on the beginning date and ending date chosen on the form. The end user process would be: 1. open form 2. pick beginning date 3. pick ending date 4. click on "Preview Report" Nice and simple, should be fairly straight forward. I expect there to be an appropriate error message if the ending date chosen is earlier than the starting date. The calendar control should default to today's date with the beginning date defaulting to the start of the current month and the end of the current month. The code must be commented properly so that I can modify it. If I get stuck you may get some more work modifying it!
## Deliverables
1) Complete and fully-functional working program(s) in MS Access as well as complete source code of all work done. 2) Must be ready-to-run and working in the MS Access database 3) Complete ownership and distribution copyrights to all work purchased.
## Platform
Microsoft Windows 98 and higher, with MS Access 2000