Dino: If you like, email your file and I'll have a look.
************
Anne Troy
www.OfficeArticles.com

"Dino" wrote in message
...
Thanks Anne. I'm still not getting the correct results. I only have 3
levels available, where I think I should have 4. Level 3 shows all detail
and it shows subtotals for City and then State, but the states are still
separate. I don't get a grand total for each state. See sample below ....

TACH LINA- RJM SEAL BEACH CA 5,764.16 345.85
SEAL BEACH Total 5,764.16
CA Total 5,764.16
TARRANCA DA LUGO SHERMAN OAKS CA 5,879.44 352.77
SHERMAN OAKS Total 5,879.44

CA Total 5,879.44

I need to see a total for all of CA. Other ideas?

Dino

--
"Anne Troy" wrote in message
...
Do it the other way around, Dino. Do the "lesser" grouping first (the one
that will group lesser records at a time), so do by City first, then by
State. You should be fine.
************
Anne Troy
www.OfficeArticles.com

"Dino" wrote in message
...
I have a database I want to subtotal by both State and City. So for
example, I want to see subtotals for individual towns such Dallas,
Houston, Cleveland and Toledo, but then I want to see totals for Texas
and Ohio.

I sorted first by State, then City and created subtotals for the sales
amounts based on the State. All is OK.

I created the secondary subtotal just like the first one except at each
change in City, and I told it not to replace subtotals. It doesn't look
right. Does any of this make sense? Any ideas what I'm doing wrong?

TIA
Dino