Grand Totals

[GoatieEddie]

Hi all,

I have created a small select query which does what I want it do! (Hooray ) It shows three columns with the last one being a count value. But what I would really like is a grand total at the bottom of the rows that adds up ALL the count values. I then want to turn it into a corsstab query and have totals at the bottom of each and every column.

Obviously this value isn't in the table so is there anyway to do this?

Many thanks,
GE

 

[jrbarnett]

Create a report based on the query and add a total to the query based on =Count([Fieldname]) in a group footer.

John

 

[PHV]

Have you tried to create a CrossTab query based on your actual query ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[GoatieEddie]

I have already done the crosstab query but without the totals. I could do a report but I was wondering whether I could just do it on the query page.

 

[PHV]

The CrossTab can't do the totals for you ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[GoatieEddie]

Doesn't seem to. The table looks good and has everything on it apart from totals at the bottom of each column. I'm so close and yet feel so far!

 

[Blorf]

Your query has your data. Maybe a second query that reads the first, with data totals only (IE, make your other fields null),then base your cross tab on a union query containing both.



There Are 10 Types Of People In The world:
Those That Understand BINARY And Those That Don’t.

http://mysite.verizon.net/res0n4sv/