Summing multiple fields

  • Thread starter Thread starter Ilan
  • Start date Start date
I

Ilan

Hello i would like to get a sum for a few different
fields for the non-for-profit organization i am doing a
database for. I have syntax like this:

=sum([field1]+[field2]+[field3]) (etc...) but i keep
getting an error. any suggestions?

Thanks,
Ilan
 
Actually they are currency fields. I tried it that way
too and it did not work. I can successfully summarize
each field individually, but when i want the grand total
that is where i get the error.

Ilan
-----Original Message-----
Are these numeric fields? Have you tried
= [Field1] + [Field2] + [Field3]

Rick B


Hello i would like to get a sum for a few different
fields for the non-for-profit organization i am doing a
database for. I have syntax like this:

=sum([field1]+[field2]+[field3]) (etc...) but i keep
getting an error. any suggestions?

Thanks,
Ilan
Click to expand...


.
Click to expand...
 
Okay, I think I see what you want. You want (in a report footer) to show
the sum of several columns (fields) in your report?

You might try to sum each item and add those together. Something like....

= sum([Field1]) + sum([Field2]) + sum([Field3])

Hopefully that will do it. If not, I am at a loss.



Ilan said:
Actually they are currency fields. I tried it that way
too and it did not work. I can successfully summarize
each field individually, but when i want the grand total
that is where i get the error.

Ilan
-----Original Message-----
Are these numeric fields? Have you tried
= [Field1] + [Field2] + [Field3]

Rick B


Hello i would like to get a sum for a few different
fields for the non-for-profit organization i am doing a
database for. I have syntax like this:

=sum([field1]+[field2]+[field3]) (etc...) but i keep
getting an error. any suggestions?

Thanks,
Ilan
Click to expand...


.
Click to expand...
Click to expand...
 
You got exactly what i wanted, however it still doesnt
work. I keep getting 0, there must be something in there
that is messed up. Thanks for your help.

Ilan
-----Original Message-----
Okay, I think I see what you want. You want (in a report footer) to show
the sum of several columns (fields) in your report?

You might try to sum each item and add those together. Something like....

= sum([Field1]) + sum([Field2]) + sum([Field3])

Hopefully that will do it. If not, I am at a loss.



Actually they are currency fields. I tried it that way
too and it did not work. I can successfully summarize
each field individually, but when i want the grand total
that is where i get the error.

Ilan
-----Original Message-----
Are these numeric fields? Have you tried
= [Field1] + [Field2] + [Field3]

Rick B


Hello i would like to get a sum for a few different
fields for the non-for-profit organization i am doing a
database for. I have syntax like this:

=sum([field1]+[field2]+[field3]) (etc...) but i keep
getting an error. any suggestions?

Thanks,
Ilan


.
Click to expand...
Click to expand...


.
Click to expand...
 
Back
Top