Problem Calculating SUms in Tabular Reports

[grantschneider]

I have created a couple reports from Crosstab queries and when I go to
sum up the columns I seem to get the number of rows as the amount
every time.

For example:
My columns labeled 1 through 10 and there are 10 rows.
I use the following command: =sum(1) then =sum(2) etc.

I then get the following results: 10, 20, 30, as the totals of each
column. Access seems to be summing the number of rows and adding the
previous sum.

Any ideas?

Grant

 

[John Spencer]

No guarantee, but the first thing I would try would be to make sure taht
Access is recognizes that you are referring to fields.
=Sum([1])
=Sum([2])


--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[grantschneider]

No guarantee, but the first thing I would try would be to make sure taht
Access is recognizes that you are referring to fields.
=Sum([1])
=Sum([2])

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
.

I have created a couple reports from Crosstab queries and when I go to
sum up the columns I seem to get the number of rows as the amount
every time.

For example:
My columns labeled 1 through 10 and there are 10 rows.
I use the following command: =sum(1) then =sum(2) etc.

I then get the following results: 10, 20, 30, as the totals of each
column. Access seems to be summing the number of rows and adding the
previous sum.

Any ideas?

Grant- Hide quoted text -

- Show quoted text -

It worked. Thanks yet again.
Grant