how can i change data in a table

B

bb

i have a table that has prices per pound in it, these prices change at least
yearly, they are used in a query to figure cost of material sold., i can
change the figures in the table , but when figures are put in form they
figure the price on the old figures. if i can get this table data to change
will it change all of the history data that has been generated from this
table.
 
L

Lynn Trapp

I'm assuming you have the price in an Items table. To keep from overwriting
the price in the individual orders, you will need to store the price in the
Orders table too. The Items table will store the current price and the
Orders table will store the price at the time of the order.
 
G

Guest

you can use an update query to update the prices in your
table. this would not effect any other data perticularly
if the data is in another table.
read up on update queries in help.
 
Top