S swarv Registered User. Local time Today, 20:27 Joined Dec 2, 2008 Messages 196 May 30, 2012 #1 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 Attachments Untitled.jpg 88 KB · Views: 143
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 Registered User Local time Today, 15:27 Joined Jun 9, 2004 Messages 13,291 May 30, 2012 #2 Do you have any null values in the prices? You may need to do something like: =sum(nz([price])
S swarv Registered User. Local time Today, 20:27 Joined Dec 2, 2008 Messages 196 May 30, 2012 #3 excellent thats it. cheers for that.
KenHigg Registered User Local time Today, 15:27 Joined Jun 9, 2004 Messages 13,291 May 30, 2012 #4 Cool - Glad it worked
