How do I ADD records in the form again?

  • Thread starter Thread starter shelley kline
  • Start date Start date
S

shelley kline

Hi there,
Can someone tell me the correct syntax for adding these
fields on a form? I'm trying this and it isn't working...

Field [AB Est]
Field [BC EST]
Field [ONT Est]
Field [ATLAN Est]


I am using =Sum([AB Est]+[BC EST]+[ONT Est]+[ATLAN Est])

But nothing is happening - the form isn't adding these
together?
 
Hi there,
Can someone tell me the correct syntax for adding these
fields on a form? I'm trying this and it isn't working...

Field [AB Est]
Field [BC EST]
Field [ONT Est]
Field [ATLAN Est]


I am using =Sum([AB Est]+[BC EST]+[ONT Est]+[ATLAN Est])

But nothing is happening - the form isn't adding these
together?
Click to expand...

Hi Shelley

Try using the NZ function..i.e.
Sum(NZ([AB Est])+NZ([BC EST])+NZ([ONT Est])+NZ([ATLAN Est]))

Maurice
 
thanks - I've tried it, but it still isn't working... not
sure why - I have the statement in the 'control source' of
the bound field box... do I need to do anything else?

-----Original Message-----
Hi there,
Can someone tell me the correct syntax for adding these
fields on a form? I'm trying this and it isn't working...

Field [AB Est]
Field [BC EST]
Field [ONT Est]
Field [ATLAN Est]


I am using =Sum([AB Est]+[BC EST]+[ONT Est]+[ATLAN Est])

But nothing is happening - the form isn't adding these
together?
Click to expand...

Hi Shelley

Try using the NZ function..i.e.
Sum(NZ([AB Est])+NZ([BC EST])+NZ([ONT Est])+NZ([ATLAN Est]))

Maurice
.
Click to expand...
 
shelley kline said:
Hi there,
Can someone tell me the correct syntax for adding these
fields on a form? I'm trying this and it isn't working...

Field [AB Est]
Field [BC EST]
Field [ONT Est]
Field [ATLAN Est]


I am using =Sum([AB Est]+[BC EST]+[ONT Est]+[ATLAN Est])

But nothing is happening - the form isn't adding these
together?
Click to expand...

If you want the sum of these values for the current record, leave out
the Sum() function:

=[AB Est]+[BC EST]+[ONT Est]+[ATLAN Est]

or (if any may be Null):

=Nz([AB Est], 0)+Nz([BC EST], 0)+Nz([ONT Est], 0)+Nz([ATLAN Est], 0)

You would only use the Sum() function for a text box in the form's
header or footer section, if you wanted a total of these fields over all
the records on the form.
 
Back
Top