Queries and reports

[Rico]

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

 

[marty]

Hello,

If you send me the exact table I'll be happy to create the
report for you (NO CHARGE). The thing is they write whole
chapters on how to do what your asking and I would have to
as well in order to explain to you how to create the
report. It would only take me around 5 minutes to give
you what you're asking for. After I send it to you, you
are free to analyze (learn from) it and make any changes
you want. The wizards for creating reports in ACCESS are
incredibly easy to use, however you do have to know the
terminology in order to make the proper selections. This
is where a good reference book may come in handy. Anyway
I do not do this for a living or anything that so I'm not
spam you.



Just thought I could help, Marty.



P.S. If you do not know how to export the table: Open the
table then Click FILE > Export or it might be FILE > Save
As. You do not have to save it as an ACCESS file it can
be anything (file format).