Totals dont' come up right

[Juan]

Hello,
I been trying to create a query with an extra field that
sum my other fields.
I try a select query then a Total and totals come up wrong.
Here's what I did first:
Total:[01]+[02]+[03]+[04]+[05]+ etc upto 12. These are
codes that show totals.
But not all codes will have data so it will be blank.
Then I try.
TOTAL:NZ([01])+Nz([02])+Nz([03])+Nz([04])+Nz([05])+Nz([06])
+Nz([07]) etc upto 13.

Some do show right data but some don't So can anyone see
why I'm getting wrong data?
I appreciate any help.
thanks,
Juan

 

[Bob Barnes]

Are the fields being added all Number Datatypes?

HTH - Bob

 

[Duane Hookom]

You should use Val(Nz([01],0))+etc...

 

[JUAN]

Hello Bob/Duanne,

I finally was able to get it right. I think I had an
extra ) which was not addign correctly. But thanks for
both of you for trying to help.
Really appreciated.

Thanks,

Juan

-----Original Message-----
Are the fields being added all Number Datatypes?

HTH - Bob

-----Original Message-----
Hello,
I been trying to create a query with an extra field that
sum my other fields.
I try a select query then a Total and totals come up wrong.
Here's what I did first:
Total:[01]+[02]+[03]+[04]+[05]+ etc upto 12. These are
codes that show totals.
But not all codes will have data so it will be blank.
Then I try.
TOTAL:NZ([01])+Nz([02])+Nz([03])+Nz([04])+Nz([05])+Nz ([06])
+Nz([07]) etc upto 13.

Some do show right data but some don't So can anyone see
why I'm getting wrong data?
I appreciate any help.
thanks,
Juan
.

.

 

[Bob Barnes]

You're welcome.

As I looked at your formula, I know "Nz" should work.
I think that debuted in Access97 as a welcome addition.

Bob

-----Original Message-----
Hello Bob/Duanne,

I finally was able to get it right. I think I had an
extra ) which was not addign correctly. But thanks for
both of you for trying to help.
Really appreciated.

Thanks,

Juan

-----Original Message-----
Are the fields being added all Number Datatypes?

HTH - Bob

-----Original Message-----
Hello,
I been trying to create a query with an extra field that
sum my other fields.
I try a select query then a Total and totals come up wrong.
Here's what I did first:
Total:[01]+[02]+[03]+[04]+[05]+ etc upto 12. These are
codes that show totals.
But not all codes will have data so it will be blank.
Then I try.
TOTAL:NZ([01])+Nz([02])+Nz([03])+Nz([04])+Nz([05])+Nz ([06])
+Nz([07]) etc upto 13.

Some do show right data but some don't So can anyone see
why I'm getting wrong data?
I appreciate any help.
thanks,
Juan
.

.

.