Multiple Sums

[Guest]

I have a report that looks like this, I know that I can group by status and
add that in the group footer of the section- but I am not sute how to handle
the other counts I need.
WO # Reason Status Tech
1 R1 S1 T1
2 R2 S1 T2
3 R1 S2 T1
4 R 2 S2 T2

What I need is to have counts in the header like
R1 2 R2 2 R3 0
S1 2 S2 2 S3 0
T1 2 T2 2

 

[Duane Hookom]

I would probably create totals queries and use them as the record sources
for subreports. Place the subreport(s) where ever you want on the main
report.

 

[Guest]

Duane:
How do I write a query to give me the toals for the options in a list box?
I am not able to get the query to give me seperate counts. Also it forces me
to enter the date range for the report multiple times.

SELECT [qry Week End WO].[First Name], Count([qry Week End WO].[First Name])
AS [CountOfFirst Name], [qry Week End WO].[Call Reason], Count([qry Week End
WO].[Call Reason]) AS [CountOfCall Reason]
FROM [qry Week End WO]
GROUP BY [qry Week End WO].[First Name], [qry Week End WO].[Call Reason];

 

[Duane Hookom]

I don't see anything in your reply that includes date range criteria. Also,
you haven't provided any information about your list box and possibly how it
is used for your main report.

--
Duane Hookom
MS Access MVP

Duane:
How do I write a query to give me the toals for the options in a list box?
I am not able to get the query to give me seperate counts. Also it forces
me
to enter the date range for the report multiple times.

SELECT [qry Week End WO].[First Name], Count([qry Week End WO].[First
Name])
AS [CountOfFirst Name], [qry Week End WO].[Call Reason], Count([qry Week
End
WO].[Call Reason]) AS [CountOfCall Reason]
FROM [qry Week End WO]
GROUP BY [qry Week End WO].[First Name], [qry Week End WO].[Call Reason];

I would probably create totals queries and use them as the record sources
for subreports. Place the subreport(s) where ever you want on the main
report.