sum error (1 Viewer)

[swarv]

Hi all,

I am trying to use =sum([price]) in the control source box in my report to add up a list of numbers in the report. the text box that has the amount in is called price.

It doesn't seem to be working. I know its a simple fix but how can I do this?

thanks

Martin

 

[KenHigg]

Do you have any null values in the prices? You may need to do something like:

=sum(nz([price])

 

[swarv]

excellent thats it. cheers for that.

 

[KenHigg]

Cool - Glad it worked