When you add the calculated fields in the form - SUMExtPrice, SUMSalesTax, SUMExtPrice+SUMSalesTax does that value save in a table or query or not at all.  Is there value in doing these calculations in a Query instead of the Form?

---

Reply from Richard Rost:

Those values are not saved anywhere, just displayed for you. WHERE you calculate them does matter sometimes. If you have a HUGE dataset you may find performance is a little better if you calculate them in a query. It will load a little slower initially, but then the results will scroll faster. In a form, each page view is calculated as you scroll. Loads faster, but slower on the scroll.