Totals & adjustments

[groen]

Sorry only just learning Access but I am really stuck so I hope someone can help me.


I am trying to adjust the Northwind Db to suit my needs. I have as per layout on order subform
Product - Unit Price - Quantity - Total.
As I buy from Cash & Carry prices for products fluctuate week by week. So I would like to be able to if necessary
adjust the unit price up or down on the orders and recalculate total with the new values.
Thanks in advance for any help.
Regards

[ranman256]

your tProduct table would have a price on the record.
when you add it to the client's shopping cart , the price goes with the product.
the footer would show the shopping cart total. =Sum([Price])