DIVIDE AND MULTIPLY A FIELD
DIVIDE AND MULTIPLY A FIELD
(OP)
I want to use the following expression in a form--to pull out partial taxes.
The form field is ADMISSION REVENUES.
=[ADMISSION REVENUES]/1.0825*0.0825
This is the expression I am working with.
Will Access divide and then multiply in the same field?
Thanks,
Gwen
The form field is ADMISSION REVENUES.
=[ADMISSION REVENUES]/1.0825*0.0825
This is the expression I am working with.
Will Access divide and then multiply in the same field?
Thanks,
Gwen
RE: DIVIDE AND MULTIPLY A FIELD
When multiplication and division occur together in an expression, each operation is evaluated as it occurs from left to right. When addition and subtraction occur together in an expression, each operation is evaluated in order of appearance from left to right. Parentheses can be used to override the order of precedence and force some parts of an expression to be evaluated before others. Operations within parentheses are always performed before those outside. Within parentheses, however, operator precedence is maintained.
Example:
(2*10)+5 = 25
2*(10+5) = 30
I hope this make sense.
HTH
RDH
Ricky Hicks
rdhicks@mindspring.com