R
Rose
I'm putting together a db for a retailer. The retailer
sometimes has sales, or sometimes a product will change in
price. Standard stuff.
What I need to do is to be able to "freeze" invoices, so
that the values in an invoice do not change should the
product prices change. In Excel, I would copy the results
and paste special somewhere else using the only the values
and not the formulas. Can I do something similar in
Access - set up a table for my line items that is a static
copy of my product prices (and the calculations based on
them)?
sometimes has sales, or sometimes a product will change in
price. Standard stuff.
What I need to do is to be able to "freeze" invoices, so
that the values in an invoice do not change should the
product prices change. In Excel, I would copy the results
and paste special somewhere else using the only the values
and not the formulas. Can I do something similar in
Access - set up a table for my line items that is a static
copy of my product prices (and the calculations based on
them)?