Adding values in row to get a total. How to do it??

  • Thread starter Thread starter DVN
  • Start date Start date
D

DVN

I want to add the values of a column together. In my
original query I had something like this.

Class Jan Feb Mar Apr ...

Accel 1 1 1 ...
ARINC 1 2 ...
Misc. 3 1 3 ...

I used the Nz function to fill the holes with zeros (i.e.
Nz([Jan],0). So every blank space now has a 0.

Now when I try to add the rows together to get a total, I
get the series of numbers rather than a total. In other
words I get:

Class Total

Accel 1011
ARINC 0120
Misc. 3130

I want to see

3
3
7

Does anyone know how to do this?
 
Thanks, that did the trick...
-----Original Message-----
Not to correct you but I think you are trying to add up
Click to expand...
the columns per row. The syntax ticket is this:
val(nz(Jan,0)) + val(nz(Feb,0)) + val(nz(Mar,0)) etc.

The val function converts the text to a number.

----- DVN wrote: -----

I want to add the values of a column together. In my
original query I had something like this.

Class Jan Feb Mar Apr ...

Accel 1 1 1 ...
ARINC 1 2 ...
Misc. 3 1 3 ...

I used the Nz function to fill the holes with zeros (i.e.
Nz([Jan],0). So every blank space now has a 0.

Now when I try to add the rows together to get a total, I
get the series of numbers rather than a total. In other
words I get:

Class Total

Accel 1011
ARINC 0120
Misc. 3130

I want to see

3
3
7

Does anyone know how to do this?

.
Click to expand...
 
Back
Top