Q.. A simple calculation

[Jim Jones]

Hi.

I've decided to say screw the database I'd been working on for over a
year. Access can't seem to handle all the functions I need.

But I am starting a new database, with a completely new project.

I can't seem to get this simple calculation working.

I have a form. Just a form, with 2 unbound text fields.

One is where you type any number, and the other is supposed to return
a value depending on what you entered in field one.

Only the calculation is coming out wrong.

In the second text box, I have entered:

=[Text2]-(32/1.8)

It's supposed to return the result of 5, if I enter 41 in the first
text box. But the formula above is returning 23.222222

Please help, ( that is, if Access can handle it),
Thanks,
Jim

 

[Jim Jones]

never mind . i got it.

 

[Cindy]

=[Text2]-(32/1.8)

It's supposed to return the result of 5, if I enter 41 in the first
text box. But the formula above is returning 23.222222

Please help, ( that is, if Access can handle it),
Thanks,
Jim

32 / 1.8 = 17.7778

41 - 17.7778 = 23.2222

Your problem lies in how mathematical functions are processed. Anything
inside brackets is processed first, followed by multiplication and
division, then addition and subtraction. Change your formula to
=([Text2]-32)/1.8 and it will return the result you expect.

Cindy

 

[Jim Jones]

=[Text2]-(32/1.8)

It's supposed to return the result of 5, if I enter 41 in the first
text box. But the formula above is returning 23.222222

Please help, ( that is, if Access can handle it),
Thanks,
Jim

32 / 1.8 = 17.7778

41 - 17.7778 = 23.2222

Your problem lies in how mathematical functions are processed. Anything
inside brackets is processed first, followed by multiplication and
division, then addition and subtraction. Change your formula to
=([Text2]-32)/1.8 and it will return the result you expect.

Cindy

Cindy,
Thanks for your response, but I had fixed it just minutes after I
posted the thread. I even replied here, but don't see it now.
Jim