Grouping reports by external data

[warmexxus]

I'm curious if this situation is possible. What I have right now are two tables: Mechanics, Mechanic_Slips. The Mechanic table has various fields that describe each Mechanic. The Mechanic_Slips table has all recorded activity by each Mechanic. What I want to do is print a report based on the Slip table, to show summary calculations for each mechanic over a certain period of time.

So each mechanic is listed only once, and there are Totals listed to the right of each line. I have this already set up. What I want to accomplish is to group this report by the "Class" of mechanic, which is stored in the Mechanic table, not Slips. So each Mechanic would be listed, but grouped by their class field.

I would think dlookup would work. I'm not familiar with join queries or if something like that would work.

Any suggestions would help me out so much..

Thank you,
Dan Murphy

 

[boblarson]

No, sorry you would need to include that in the report's underlying query in order to group it. Otherwise Access doesn't have the tools to work with (the data which tells it which group is which for the data).

 

[warmexxus]

Ok thank you. Fantasic site BTW. It has a tutorial section on lookups and queries. That is probably exactly what I need to do. Thanks a bunch.

Dan