By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,486 Members | 2,124 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,486 IT Pros & Developers. It's quick & easy.

Expressions calculation Help Please!

P: n/a
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

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
AP
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

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.