total of grouped counted numbers

L

Lila

I would like to display the total of 5 numbers in a query along with their
subtotals. These 5 numbers are grouped by one field, so they look like this:

a 4 6 7 2 6
b 2 7 1 4 3

I would like a total, which would look something like

a 4 6 7 2 6
b 2 7 1 4 3
T 6 13 8 6 9

The SQL View currently looks like the following

SELECT [Total Loss Info].Perm_PermitLocation, Count([Total Loss
Info].Info_AddressName) AS [Number of losses],
Count([Perm_DatePermitIssued])-Count([Perm_DateCertOccupancy]) AS [Under
Construction], Count([Total Loss Info].Perm_DateCertOccupancy) AS Complete,
Count([Total Loss Info].Lawy_DateSuitFiled) AS [Law Suits Filed],
Count(IIf([Info_SaleDate]>#10/31/2003#,[Info_SaleDate],Null)) AS [Sold After
Disaster]
FROM [Total Loss Info]
GROUP BY [Total Loss Info].Perm_PermitLocation;

I did a separate query that gives me the total:

SELECT DISTINCTROW Sum([Status of lots].[Number of losses]) AS [Sum Of
Number of losses], Sum([Status of lots].[Under Construction]) AS [Sum Of
Under Construction], Sum([Status of lots].[Complete]) AS [Sum Of Complete],
Sum([Status of lots].[Law Suits Filed]) AS [Sum Of Law Suits Filed],
Sum([Status of lots].[Sold After Disaster]) AS [Sum Of Sold After Disaster]
FROM [Status of lots];

....but I need to combine it all in the same report (preferably some sort of
chart as well as a grid) and since the second query is based on the first
query, it won't let me combine the two!

Ideas???
 
Top