Query Totals

[tryn2learn]

I have 7 categories each with 10 sub categories.
(Example) main group is: “Personalâ€
sub groups under “Personal†are

Billing
Letters
Fin State
Post
NCO
Can/Terms
Mech
FldPol
FltPol
Cut

is it possible to run a query that will looks at all the subgroups under the
main group and give me totals for each?

(example)

Personal:

Billing - $$$.$$
Letters - $$$.$$
Fin State- $$$.$$
Post- $$$.$$
NCO- $$$.$$
Can/Terms- $$$.$$
Mech- $$$.$$
FldPol- $$$.$$
FltPol- $$$.$$
Cut- $$$.$$

 

[Klatuu]

Use a totals query. You can do that in the query builder by clicking on the
totals icon. It looks like the Greek letter Sigma.

The use Group By for the group and Sum for the subgroups.

 

[KARL DEWEY]

Use a total query like this ---
SELECT Your_Table.Personal, Sum(Your_Table.Cost) AS SumOfCost
FROM Your_Table
GROUP BY Your_Table.Personal;

 

[tryn2learn]

That's great! Thank you both very much for your help and quick reply.