Totals dont' come up right

  • Thread starter Thread starter Juan
  • Start date Start date
J

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
 
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
.
Click to expand...
.
Click to expand...
 
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
.
Click to expand...
.
Click to expand...
.
Click to expand...
 
Back
Top