• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

Anyone good with Access?

C

ChaoZ

Diamond Member
I'm trying to update revenue from past movies adjusted to inflation in a query. The inflation rate is 2%. Here's my formula:

AdjustedBoxOffice: [tinventory]![BoxOffice]*(1+0.02)^2007-[tinventory]![YearReleased]

So I just took 2007 and subtract the year of release to find 'n'. The numbers aren't coming out to what I want it to be.
 
How are you identifying a unique record in your table?

I can't really help without seeing your table structure and what your query looks like.
 
But for one your formula is wrong:

(BoxOffice * (1 + 0.02) ^ (2007 - YearReleased))

Or better yet, a formula which would work no matter what year it was currently:

(BoxOffice * (1 + 0.02) ^ (DatePart("yyyy", Date()) - YearReleased))

Basically it's an order of operations problem.

Since you didn't have (2007 - Year Released) in parens, it was taking the result, to the power of 2007, and then subtracting the YearReleased from that.

Also to get the year I believe you could just do Year(Date())
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top