Total in Group Query

[JackGat]

I have a query where I group on customer states and count the number of customer last names in each state.

My query looks like this.
State Countof Lastname
NJ 5
NY 6
CA 10

Is it possible to include the sum in the same query?

I want my query to look like this.
State Countof Lastname
NJ 5
NY 6
CA 10
Total 21

Any advice is greatly appreciated.
Cheers.

 

[dhookom]

You can use a union query to display the sum line/record at the bottom of the other records.

Typically totals are displayed in the footers of forms and reports.

Duane
Hook'D on Access
MS Access MVP