Group Totals and Totals

[khinester]

Hello,
I am trying to do a report which will first list all the
duplicate records and then sum these up.

I've got the first part working by, creating a query
which lists the fileds that have the duplicates and then
adds a value of 1, here is the sql:

SELECT [Tbl SLH Subscriptions].[Category Type], 1 AS Expr
FROM [Tbl SLH Subscriptions];

Now, I have a report onto which I've added a CategoryType
footer under which I have =Sum([Expr])

This gives me the total of each repetion.

Now my question, is how do I add the main total records
for that query?

I guess it will be the whole dataset, but how do you
return this in a report?

Cheers