Compounding formula in Access

[Guest]

I have salary data that I need to age by a specific percentage. I know I can
do this in Excel with the following formula.

=(A1^B1)+C1
(where A1 is the percent to age by, and B1 is the value representing the
difference in two dates used to age the data, and C1 is the original salary
data)

I have all other data sets in place (A, B and C above). The only thing I
need to know is if there is an easy way to incorporate compounding/prime (^)
into an access query?

 

[Jeff Boyce]

Danielle

If I'm understanding, you have three columns (A, B, C) and wish to calculate
(A^B)+C.

You can do this in a query -- open in design view, add the table with A, B,
C, and create a new field, something like:

NewField: ([A]^)+[C]

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Guest]

Thanks Jeff - Perfect, I've tried using prime in the past and for whatever
reason - maybe paren or field types - couldn't get it to work.

- Danielle

Danielle

If I'm understanding, you have three columns (A, B, C) and wish to calculate
(A^B)+C.

You can do this in a query -- open in design view, add the table with A, B,
C, and create a new field, something like:

NewField: ([A]^)+[C]

Regards

Jeff Boyce
Microsoft Office/Access MVP

I have salary data that I need to age by a specific percentage. I know I
can
do this in Excel with the following formula.

=(A1^B1)+C1
(where A1 is the percent to age by, and B1 is the value representing the
difference in two dates used to age the data, and C1 is the original
salary
data)

I have all other data sets in place (A, B and C above). The only thing I
need to know is if there is an easy way to incorporate compounding/prime
(^)
into an access query?