Formulas for Beginners

  • Thread starter Thread starter Chris Peikert
  • Start date Start date
C

Chris Peikert

I am trying to figure out how to do math in Access. When I do it on paper I
use one set of symbols but when you use computers it doesnt take those
symbols. So where do I find what symbols are used and how to use them in
what order?
 
Plus and minus are the same. Multiplication uses an asterisk (*) and
division uses a forward slash (/).

Isolate separate parts with parenthesis like (4-2)*2 instead of 4-2*2 or
(2*4)+5.
 
Thanks. The information contained there is hard to follow but thats pretty
much what I am looking for. Just wish it gave some better examples.
 
I knew those symbols i was just curious about stuff like Square Root,
Squared, Cube, less than or equal to, and other math signs not in the
computer.
 
I knew those symbols i was just curious about stuff like Square Root,
Squared, Cube, less than or equal to, and other math signs not in the
computer.
Click to expand...

Most of these do not have operators. The ^ operator lets you do a "to
the power of" operation, e.g. [X]^3 is x cubed. Some operations simply
have VBA functions defined - Exp([X]) or Log([X]) for example. There
are all the inequality operators < <= > >= <> of course.

John W. Vinson[MVP]
 
You can get roots by using this format

[X]^(1/3)

That returns the cube root of X

John Vinson said:
I knew those symbols i was just curious about stuff like Square Root,
Squared, Cube, less than or equal to, and other math signs not in the
computer.
Click to expand...

Most of these do not have operators. The ^ operator lets you do a "to
the power of" operation, e.g. [X]^3 is x cubed. Some operations simply
have VBA functions defined - Exp([X]) or Log([X]) for example. There
are all the inequality operators < <= > >= <> of course.

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