Field Totals only

B

Beep Beep

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.
 
K

KARL DEWEY

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];
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top