Run a math formula (newbie question)

  • Thread starter Thread starter chang
  • Start date Start date
C

chang

Is there a way that i can have access run a math formula:
2 formulas, one to convert one type of weight to another (metric tons to
short tons). so i would enter one and it will display the conversion

and the other is letsd say some of them have different weights per feet so
i would preenter the ratio, and then i would choose which one, and then
enter the length, and it will then give me the total weight.

thank you
 
That is relatively easy to do, assuming you only want the results on the
screen, not saved. Create a form with 3 text boxes, a combobox, and a
command button. The combobox can have as a record source, a table or a
value list. Use the combobox wizard to create a value list. Name your
textboxes ShortTons, MetricTons, TotalWt, TotalLength as below:
Private Sub cmdCompute_Click()
Me!ShortTons = Me!MetricTons * 1.1
Me!TotalWt = Me!TotalLength * Me!cbxWtperFoot
End Sub

Note that there is no error checking here -this is barebones!

HTH
Damon
 
Is there a way that i can have access run a math formula:
2 formulas, one to convert one type of weight to another (metric tons to
short tons). so i would enter one and it will display the conversion

and the other is letsd say some of them have different weights per feet so
i would preenter the ratio, and then i would choose which one, and then
enter the length, and it will then give me the total weight.

thank you
Click to expand...

In a Form, Report, or Query you can do all of those things.
Directly in a table you cannot.

Now if you need help with doing so, post back with the formulas and
I'm sure some one will show you how to write it and where to place it.
 
In a Form, Report, or Query you can do all of those things.
Directly in a table you cannot.

Now if you need help with doing so, post back with the formulas and
I'm sure some one will show you how to write it and where to place it.
Click to expand...




I want it that i will have a form to enter information, i will choose
from a drop down a list a customer name (which all of his info gets
enterd into from another form). i will then coose a "pipe style" (i
will have set the ratio of weight per foot using a different form) the I
want to be able to enter the Metric weight of the sale and also enter
the total price that i am paying for it and the total price that i am
selling it for. I then want it to calculate the weight in "Short tons"
(it is a simple mutiplication formula) . I also what it to display the
price per foot (for both me and the customer) based on the ratio that is
for that pipe style. and I nead it to save the information.

I know how to do the basics, but how to set it up to deal with the
formulas and to save information is what i nead help with.
 
Back
Top