Creating reports based upon dates entered by user

[DivaSupreme]

Help!?!?! I have a table which has a date field along with other associated information. I have created a form that has 2 combo boxes, a Start Date field and End Date field, which prompts the user to select a date from the drop down box (the dates are stored in the table)

How do I set up the report so that it shows the info associated with the dates selected by the user?

 

[Mich2too]

An easier way to accomplish this is in a query. Set the query up to include all of the fields you want in the report. Set up your report in the layout you want. Then go back to your query in Design mode...In the Criteria line of your date field type in.... Between[Enter starting date]and[Enter ending Date]....this will prompt your user to enter the starting date they want in the report, then will prompt them for the ending date. I suggest setting up your report the way you want it before tweaking your query to save you from being pestered to death while working between the report page preview and report page design modes. I learned the hard way...LOL....Good luck.

 

[Mich2too]

You may wish to ignore my previous posting. This is just the way I've accomplished similiar situations in the databases worked with. However, being a new user to Tek-Tips, I should probably have kept my mouth shut for awhile. And being unfamiliar with VBA, there is probably an easier way to do this using VBA. Sorry.

 

[emzadi]

I get my user input dates through a query, as you suggest... however, how do I get that date range to appear in the header of my report?

Thanks,
Emzadi Susan M. Wagner
LAPELS
susanw@lapels.com

 

[MichaelRed]

Ssusan (Emzadi) M. Wagner,

See the following thread (Just dblClick on it) for some (relevant?) thoughts.

Thread702-58272
MichaelRed
redmsp@erols.com

There is never time to do it right but there is always time to do it over

 

[emzadi]

Sorry, Michael, the link did not work. Susan M. Wagner
LAPELS
susanw@lapels.com

 

[MichaelRed]

(Suddenly?) Susan,
Sorry it works fine for me. It is in the MS Access Forms Forum, thread is by "TAMARK", Dated 2/26/2001.

"Putting Dates Into ... "


MichaelRed
redmsp@erols.com

There is never time to do it right but there is always time to do it over