Summary Report

F

Fons Ponsioen

Without having provided more specific data as to your
table structure, the only suggestion I can give is to use
grouping and/or a subreport with its own query(ies) which
can make you report very flexible.
Post back with more detail if needed.
Hope this gets you started.
Fons
-----Original Message-----
I have a detail report that groups records by department
and machine number for a selected week, ie wk 23,24,etc. I
would like to produce a summary report that shows only
department totals, ie dept1, dept2,dept3 etc , number of
unique machines used per department, and total hours
worked for each department. Any suggestions on how to do
this. I can count the machines, based on the groupinging
for the detail report, but lose them when I try to do a
summary report. Any suggestions would be appreciated.
 
Top