Hi
I have a quote form and a sub form for quote lines within the quote form.
On the sub form I have 4 main fields
ID
Building description
Price
Report price
The quote may have many lines of bulding prices, so I ahve used an Add button for this.
On the finla line I also put in the report price.
I now need a Total price field adding in somehow, but cant figure out how to add it in.
The prices to add have the quote id next to them, so I need a total of all prices and report price where it is equal to the quotenumber it is attached to (hope that makes sense)
Could someone point me in the right direction
Thanks
I have a quote form and a sub form for quote lines within the quote form.
On the sub form I have 4 main fields
ID
Building description
Price
Report price
The quote may have many lines of bulding prices, so I ahve used an Add button for this.
On the finla line I also put in the report price.
I now need a Total price field adding in somehow, but cant figure out how to add it in.
The prices to add have the quote id next to them, so I need a total of all prices and report price where it is equal to the quotenumber it is attached to (hope that makes sense)
Could someone point me in the right direction
Thanks
