Help with Expression

S

Sandie

I have entered an expression in a form field to calculate a sum. I cannot
seem to get it to perform this function. Where exactaly does the calculation
need to be?
 
R

Rick Brandt

Sandie said:
I have entered an expression in a form field to calculate a sum. I
cannot seem to get it to perform this function. Where exactaly does
the calculation need to be?
Click to expand...

A sum of what?
What is your current expression?
Are you trying to add fields on one record or sum a field from all the rows?
 
S

Sandie

=[City Engineer Fee]+[County Building & Codes Fee]+[State Water Fee]+[NOI
Submitted Fee]+[Class V Fee]+[ARAP Fee]

I have several rows of data and I just want a sum of them all (expression
copies above).
 
R

Rick Brandt

Sandie said:
=[City Engineer Fee]+[County Building & Codes Fee]+[State Water
Fee]+[NOI Submitted Fee]+[Class V Fee]+[ARAP Fee]

I have several rows of data and I just want a sum of them all
(expression copies above).
Click to expand...

That sounds contradictory. Your expression is adding *fields* and then you
state you want to sum several rows of data. Which is it?

The expression you have should produce a sum of all of those fields unless one
or more of them is null. If any can be null then you need to wrap each operand
in the Nz() function to treat them as zero.

=Nz([City Engineer Fee])+Nz([County Building & Codes Fee])+Nz([State Water
Fee])+Nz([NOI Submitted Fee])+Nz([Class V Fee]+[ARAP Fee])

To provide a "sum of this sum" you would use...

=Sum(Nz([City Engineer Fee])+Nz([County Building & Codes Fee])+Nz([State Water
Fee])+Nz([NOI Submitted Fee])+Nz([Class V Fee]+[ARAP Fee]))
 
Top