P
punking315
i have a simple database that tracks jobs. The problem I have is that the
materials price for jobs changes frequently. I have a query that is used as a
subform for each job. this subform is where I select the different materials
used that day with price (using a combobox).
As time goes on the materials prices change, and that changes the price of
my previous jobs values, since it is calculated on the fly by my query.
I would like to know how to store or preserve the prices as I go along.
thanks for any help.
materials price for jobs changes frequently. I have a query that is used as a
subform for each job. this subform is where I select the different materials
used that day with price (using a combobox).
As time goes on the materials prices change, and that changes the price of
my previous jobs values, since it is calculated on the fly by my query.
I would like to know how to store or preserve the prices as I go along.
thanks for any help.