Richard,
I'm having a problem because my db is a little different than here. You see, I have another table called PricesT which is made up of Product ID, Price and Starting date. I use this table to update prices for each product.

My orderDetail Query gets its price from this table. Somehow, I cannot add to the query perhaps because of the calculation and different tables.

Help please!
Abdel

---

Reply from Richard Rost:

You want to keep a history of prices. Smart. You probably have a query that's not updateable because of your joins, however. I'd need to see your database to tell you how to fix it. Try removing tables from the query one at a time and that will show you which one is causing the problem.