Count and Sum

[aftabn10]

I have managed to write a query that counts a persons name to give me a figure of how many times a person appears in another table. What i would like to do is to add a total field in the last cell, for example:

Humpty | 8
Dumpty | 3
Mickey | 2
Mouse | 9
TOTAL | 22

If somebody could please help me, would really appreciate it. Thanks in advance.

 

[pbaldy]

It is simpler to total them up on the form or report you present the data with. If you really want to do it with a query, you need to use a UNION query to join your original query with another totals query that totals all records.

 

[aftabn10]

Thanks pbaldy, ill have a look at how to create a union query. thanks once again.