Can access work with multiple FX rates?


S

stelladimare

I have to produce a monthly report that uses employees data. The yearly
salary will be in local currency and I will need to create a query (and a
report) to divide the salary by 12 so I get the monthly gross salary and each
month I will need that monthly figure to be calculated in USD. But the FX
will change on a monthly basis (but the past months will stay the same). can
access do that if I have a table with the FX rates by market and month? Every
month I will update the FX rates and will need the monthly figures to
re-calculate. THANK YOU!
 
Ad

Advertisements

A

Arvin Meyer [MVP]

There are 2 methods of handling history. The preferred method is to store
the elements of the historical calculation and recalculate in a query. The
other method is to store the results of the calculation and subsequently
query those. Storing the elements also allows other calculations based upon
those elements and more closely follows database relational set theory and
normalization rules.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top