Sum a columm in a form

[Angelo]

Hi, if you are reading this is because you are trying to help me, so, first of all very thank you! Lets go!

I have a subform whith rows (2, 3 or 10) where I put the products that I sell within a form whith the client address.

In the subform I have a field supose to sum the product total (quantity * price), but I cant fix the formula. I used to sum the columm "=sum([quantity * price])" and got a #Error.

What happened?

Are there a special syntax to use the "=sum()"?? Or I cant use to sum the columm?

 

[John Big Booty]

First up welcome to the forum.

Check the DB posted here.

 

[Angelo]

Very Thank you! You are the best! So useful you exemple!!