Subtotal and Grand Total in Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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;
 
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
 
Access is so incredibly limited, I don't know how anyone can stand to use it.
Thanks much for your response.
 
Back
Top