Sum function generating syntax error.

  • Thread starter Thread starter Paolo
  • Start date Start date
P

Paolo

This:

=sum(nz([InvoiceCost],0))

generates a syntax error when put in as a control source for an unbound
textbox in the footer of a subform, whereas:

=sum(nz([InvoiceCost]))

is perfectly acceptable.

Any ideas why?

Thanks in advance,

(e-mail address removed)
 
Paolo said:
This:

=sum(nz([InvoiceCost],0))

generates a syntax error when put in as a control source for an
unbound textbox in the footer of a subform, whereas:

=sum(nz([InvoiceCost]))

is perfectly acceptable.

Any ideas why?

Thanks in advance,

(e-mail address removed)
Click to expand...

For most of us, that syntax looks quite OK. Some of us, though, lives
non default places ;-) where comma is used as decimalseparator, where
usage of semicolon is more appropriate. Could that be the case where
you reside?

=sum(nz([InvoiceCost];0))
 
Thanks Roy,

Yes I have my computer set to Italian region. Works now.

(e-mail address removed)
Paolo said:
This:

=sum(nz([InvoiceCost],0))

generates a syntax error when put in as a control source for an
unbound textbox in the footer of a subform, whereas:

=sum(nz([InvoiceCost]))

is perfectly acceptable.

Any ideas why?

Thanks in advance,

(e-mail address removed)
Click to expand...

For most of us, that syntax looks quite OK. Some of us, though, lives
non default places ;-) where comma is used as decimalseparator, where
usage of semicolon is more appropriate. Could that be the case where
you reside?

=sum(nz([InvoiceCost];0))
Click to expand...
 
Back
Top