creating a report and getting total from a crosstab query

[Guest_imported]

I'm a newbie at using access and also using this discussion group. Hopefully someone can help. Probably a real simple question. I created a report based on a crosstab query of a database. In the crosstab query and report I have the following fields:

Level Total Yes No

A 100 60 40
B 50 20 30
C 80 70 10

What I would like to do in the report is total up the numbers that are in the Total column so that I have a total that says Total: 230
I tried using COUNT in the report footer but no luck gives me ERROR.
These numbers can change when the database is updated so need it to be automatic.
Like I said probably a simple question but can't seem to get it.

Thanks,

Dan
danpage@pch.gc.ca

 

[JoeMiller]

Two methods!

Method 1
In your report footer, make a control that has a ControlSource of:

=Sum(nz([ControlNameHoldingTotalField]))

Method 2
In your report footer, make a control that has a ControlSource of:

=DSum("[Total]","MyCrossTabQuery&quot

I would go the first route because it should return faster results. Joe Miller
joe.miller@flotech.net

 

[JoeMiller]

Sorry, I boo-booed! In Method 1, change ControlSource to this:

=In your report footer, make a control that has a ControlSource of:

=Sum(nz([Total]))
Joe Miller
joe.miller@flotech.net