Sum problem with Access 2003 1

[wokkie]

Hi,

I have a continuous form with orders in it, description, price etc.

I want to have a field in the footer which will show the sum of the prices, =Sum([txtPrice)] but this shows #Error.

I would also like to do a count =Count([txtItemID]) but this doesn't work either.

I am sure that I have done this in Access 2000 and can't see what it isn't working here.

Does anyone know how to do what I want?

Thanks,

Ian

 

[RoyVidar]

From your description, it seems you're trying to use the sum function on form controls, try using the names of the fields the controls are bound to.

Roy-Vidar