Connecting Tech Pros Worldwide Forums | Help | Site Map

Expressions calculation Help Please!

william cline
Guest
 
Posts: n/a
#1: Nov 13 '05
Hello,
I am just trying to create a simple ms access database for a collection.
Anyway I am trying to compute a margin price based on a percentage added to
the orginal cost. For some reason I am unable to get the text box to
display the computation. Where in the properties dialog box do I put the
expressoin to display the currency price I want? and how do I convert the
percentage to a number to be added to the ogrinal price. Below is the code
I have.

([Orignial Price]+( [Margin Precentage] /100))

Thanks for any help. William




AP
Guest
 
Posts: n/a
#2: Nov 13 '05

re: Expressions calculation Help Please!


The expression would be placed in the controlsource property of the
text box (be sure to place an equal sign in front of your expression.
If I understand correctly you are trying to increase the original cost
by a percentage?

In this example lets say that the original cost is 100 and the margin
is 50%. To calculate the 'price' you could use this formula:

=cost + (cost * margin). If you get the percentage as a whole number 50
then the function would be something like this

= cost + ( cost * (margin/100))

Hope this helps. Let me know if I misunderstood your request.
Thanks
AP

Closed Thread


Similar Microsoft Access / VBA bytes