Sum function generating syntax error.

[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)

 

[RoyVidar]

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)

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))

 

[Paolo]

Thanks Roy,

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

(e-mail address removed)

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)

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))