queries and reports

[commanderrico]

I have a table of downtime for specific machines that is organized as follows:
Date: Shift: Start Time: End Time: Total mins: Area: Problem:

What I want to do is be able to create a report that shows me total downtime for each shift and then shows be total downtime for each area. There are about 25 different areas and it would be difficult and cumbersome to create a query for each area for each shift. Is there a way that a user can select which shift they want, then which area they want without having to make so many queries? For example, the way I want the report set up is with the total downtime for the shift at the top and then the downtime broken down on the rest of the report by area by displaying total downtime for that area. Hope this makes sense, thanks

Rico

 

[LonnieJohnson]

1. Build a form that has the Area and Shift as two different combo boxes.
2. The user could select which combination of the two they wanted.
3. Have a button on your form that opens the report in question.
4. The report would have as it's recordsource a query that has criteria expressions that point to the above mentioned form.

That's the simple and common way that such is done. This is really not a hard task, but may need further explanation based on your experience.

Let us know what further explanations you need.



ProDev, MS Access Applications
Visit me at ==>

http://www.prodev.us

Contact me at ==>lonniejohnson@prodev.us

May God bless you beyond your imagination!!!

 

[commanderrico]

Because I'm kinda new at this I think I'll need a little more to complete the task, such as how to program the button and what to put in the query. Thanks

Rico

 

[LonnieJohnson]

Email me at the address below. I will send you a demo. Please be let me know who you are and the problem we are discussing.



ProDev, MS Access Applications
Visit me at ==>

http://www.prodev.us

Contact me at ==>lonniejohnson@prodev.us

May God bless you beyond your imagination!!!