Subtotal and Grand Total in Query

Q

quartz

I have an Access query on a single table in which I would like to obtain
subtotals by "Posted_Date" ("Amount" column) as well as a grand total.

My code so far follows. Could someone please show me how to do this? Thanks
much in advance.

Select Distinct
Posted_Date AS Posted_Dt,
Effective_Date AS Effective_Dt,
SUM(Amount) AS Sum_Amount,
COUNT(Account) AS Row_Count,
Source1 AS Type
FROM
AR_ALL_2004_04
WHERE
Source1 = "FOCUS" AND
Account LIKE "###.###.####.######.###.##.###"
GROUP BY
Posted_Date,
Effective_Date,
Source1
ORDER BY
Posted_Date;
 
F

Frank Stone

hi,
Querys are not designed to show things like subtotals and
totals. it can be done but you would need seperate queries
of each. reports that use the query as a recordsourse are
where you display Totals and subtotals.
Regards
Frank
 
Q

quartz

Access is so incredibly limited, I don't know how anyone can stand to use it.
Thanks much for your response.
 
Top