Hi All, this is my first post & new to ms access, wish your help
In Northwind template 2010, where or how is the 'order subtotal' get calculated?
Order table has calculated field ordertotal=ordersubtotal+tax
Ordersubtotal has ExtendedPrice=UnitPrice+quantity+(1-discount)
I can't really find in a query or macro how subtotal get calculated.
sound naive but really puzzled with it. Appreciate your help.
In Northwind template 2010, where or how is the 'order subtotal' get calculated?
Order table has calculated field ordertotal=ordersubtotal+tax
Ordersubtotal has ExtendedPrice=UnitPrice+quantity+(1-discount)
I can't really find in a query or macro how subtotal get calculated.
sound naive but really puzzled with it. Appreciate your help.
Last edited:
