how do i perform calculations on forms?

[maeg]

my form is set out in the following way:
item 1 price
item 2 price
item 3 price
item 4 price
etc. (there are 10 items in total)

i would like to add all of the prices together to produce a total at the bottom. i have tried performing a calculation in a text box but it will not work as some of the price fields are blank... i am given this message: #Error
is there any way that i can get around this problem?
i would be really grateful if anyone knew how i could add them together including the blank fields! thank you

 

[SQL_Hell]

Hi,

is your form based on a query?

 

[R6Flyer]

Insert an unbound textbox in your form and set its control source to:

=Nz([item 1 price],0)+Nz([item 2 price],0)+Nz([item 3 price],0)+....+Nz([item 10 price],0)

That should get round your #Error problem