Field Totals only

[Guest]

I have a report that has only two fields on it. One is a severity field and
the other is a priority field. The secerity fields can be High; Medium; Low
and the priority fields can be 1, 2, 3, or unknown. My report is showing the
following:
Severity High: Priority 1 = 3; 2 = 6 3 = 4 etc. etc. The report shows
detail for each and a total of 13.
What I would like to do is just show the total per severity and priority
and not the detail.

 

[Guest]

Try these two queries ---
IncidentTally ---
SELECT 1 AS 1, "Severity" AS Type, IncidentTable.Severity AS Total
FROM IncidentTable
UNION ALL SELECT 1 AS 1, "Priority" AS Type, IncidentTable.Priority AS Total
FROM IncidentTable;

TRANSFORM Count(IncidentTally.Total) AS CountOfTotal
SELECT [Type] & " " & [Total] AS Expr1
FROM IncidentTally
GROUP BY [Type] & " " & [Total]
PIVOT IncidentTally.[1];