Reports by selecting a date range

[keiath]

Hi

Bit new to the reporting part of this program

I want to know is there a way when you click the report it asks for a start date and end date, for it to report on dates within dates selected base on a dates in a field a table.

Hope that Makes Sense

Thanks

[JoeM]

Make your Report based on a Parameter Query, i.e. in your Query that the Report is based on, enter this in your Criteria section under that Date field:
Between [Enter Start Date] and [Enter End Date]

Then whenever you run this Query (or any Report based on this Query), it will prompt you to enter a Start and End Date, and report accordingly.

[keiath]

Thanks that worked perfect, one extra question I want to do another report but this time not by date but by selecting from a combo box a "Managers" name, is this done in the same sort of way?

[JoeM]

You cannot use a Parameter Query to do something like that directly, without the use of a Criteria Selection Form.

[keiath]

Thanks i will have to see how to do that

[JoeM]

If you search this site or Google it, you should be able to find a bunch of information on it.
If you have any troubles implementing it, post back here.

[keiath]

Okay I got the form so I can now select what manager i want the report based on, and on click it run the query, the query gives me the correct information, the problem is, is how do I then generate a report?

I tried basing the report on the query but when i run that it not opening the form to select to run the query

[JoeM]

You should be able to do it something like this: http://www.techrepublic.com/blog/mic...-access-form/#.
But instead of having the command button open your query, have it open a Report based on your query.

[June7]

What do you mean 'not opening the form'? The form should already be open, then open the report.

[keiath]

You should be able to do it something like this: http://www.techrepublic.com/blog/mic...-access-form/#.
But instead of having the command button open your query, have it open a Report based on your query.

Hi Got it working thanks

[JoeM]

Great! Glad to hear it!