Not quite right

[Neo]

I have a sales order form. The user adds parts to a customers order. The form then calculates the total price using this formula

Total Price = Sum([SellingPrice])*([Quantity])
the problem is that is the user add parts to the order and the Quantities are are the same e.g. one of every thing it works

but if the users adds 1 quantity of one part and 2 of another the calculations don not work

If you have a look at the DB you can see.

I bet it is some thing simple but I can not work it out

PLEASE CAN ANYONE HELP

Thanks

 

[mark curtis]

In qrySubOrder place the following in a new field.

TLP: [SellingPrice]*[Quantity]

In the sub form change the source of the Total field to TLP.

In the footer change the source of Sub Total to Sum([TLP])

Problem solved!!