I figured it out. The main problem was to have the data converted to numbers
from text. Text imported from Access. I put the age ranges in the data area
and the type in the column area. The age ranges go in as "count of age
range". I conveted them to "sum of age range", added in a total column to
get the sum at the bottom of the table, added titles, ect and am done.

Thanks,

"Ken" wrote:

I have a database with type and age ranges in columns. Six age ranges. One
type column. The data (dollars), by type and age range are below each age
range column. I want a summary report that sums the dollars by type and age
combined. My preference is to have the sum of age ranges in the rows, the
type in the columns with the dollar sum of each type and age range in the
data fields. I hope to have the sum of the types for all ages on the right
and the sum of the ages for all types at the bottom. It seems simple enough
but,

I don't seem to be able to make the table work?