Lock down data in queries

[NickOrdinParis]

Hello there,

I have a query that calculates price x quantity. That bit is easy. However from time to time my suppliers will issue a detailed quotation (ie lots of items, lots of prices and lots of quantities), then one week later issues the exact same quotation but with price changes and/or quantity changes. I need to show to my client the progression of the costs, so the calculated (price x quantity) column has a cost at (date) heading that needs to be updated regularly. I am looking for a way in my query to lock down the data in in the calculated column at each date, so that when I get a revised quotation, I don't have to re-enter all the items, I just change either the price or quantity. Is there a way to do it ? This is about as clear as mud, but I hope someone out there understands. Thanks for your help.

 

[neileg]

You could copy the data to a table, make the amendments and append the data back to your original table but with the new date to ensure you keep the old and the new data.

 

[NickOrdinParis]

Thanks Neil, That's not such a bad solution. I'll play around with that idea. I was originally from Hartlepool, not too far from Newcastle, so I appreciate your Andy Capp logo.
Cheers

 

[neileg]

Ah, we're not allowed to use terms like monkey hangers these days, are we?

I think I'd rather be living in Paris, too!