How do I save values instead of variables in Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

RetailPrice=Cost*MarkUp. This expression is in a Form that shows orders. Cost
and MarkUp are fields in the records of their appropriate tables. If later
the value of MarkUp is changed, how do I keep the value of RetailPrice on the
forms showing old ordrs from changing. Thanks for any help
 
Jim,
You need to save Cost and Markup when you create the sales record. If
you had a "sales invoice" type table, you'd need to have a [Cost] and
[Markup] field. At the time you create the sales record, you would
determine the cost (via lookup, combo, etc...) and the markup (via lookup,
combo, etc...) and save it to the [Cost] and [Markup] field.
Of course, no need to save RetailPrice since you can always recalc that
whenever you need it, from Cost and Markup.
hth
Al Camp
 
Of course, no need to save RetailPrice since you can always recalc that
whenever you need it, from Cost and Markup.
Click to expand...

.... unless (as John says in another thread) the Markup changes over
time but he wants to save the RetailPrice using the markup which was
in effect at the time of purchase.

John, see your other thread for a suggestion. Hint: it's rarely a good
idea to start a new thread on the same question!

John W. Vinson[MVP]
 
Hi John (Vinson),
JimMike originally wrote...forms showing old ordrs from changing.

You wrote...
... unless (as John says in another thread) the Markup changes over
time but he wants to save the RetailPrice using the markup which was
in effect at the time of purchase.
Click to expand...

Hmmm... if...
Cost = $100 and Markup = 10% then RetailPrice = $110
Later if Markup goes to 15% I thought JimMike still wanted to see $110...
not $115.
So, saving Cost and Markup at the time of puchase should do that, and... any
subsequent recalc of Retail Price would produce the original value.

Now you've got me really puzzled as to what was wrong with my response.
Could you clarify?

Thanks John,
Al Camp
 
Cost = $100 and Markup = 10% then RetailPrice = $110
Later if Markup goes to 15% I thought JimMike still wanted to see $110...
not $115.
So, saving Cost and Markup at the time of puchase should do that, and... any
subsequent recalc of Retail Price would produce the original value.

Now you've got me really puzzled as to what was wrong with my response.
Click to expand...

Nothing, other than than that my mind was working backwards when I
read it. You're right, he wants to see $110, so it is necessary to
STORE not to calculate the value. Sorry Al!

John W. Vinson[MVP]
 
Good deal! Thanks John.
Al Camp

John Vinson said:
Nothing, other than than that my mind was working backwards when I
read it. You're right, he wants to see $110, so it is necessary to
STORE not to calculate the value. Sorry Al!

John W. Vinson[MVP]
Click to expand...
 
Back
Top