Help please

[damienbanda]

I am a novice access user,

I two fields in my database, Net Amount and Tax that need to be
converted from US Dollars to GB Pound, in the following manner


from June 2006 (8.7260 shillings = 1MK) going backwards
separate monthly rates for each of July (8.8417 shillings = 1MK),
August (9.0909 shillings = 1MK), and September (9.1491 = 1MK).

But it should also be able to allow entry of new rates in the future.

How can I achieve this either in VB or in Access

 

[Allen Browne]

Damien, there is a bit of work to get this kind of thing working
efficiently.

In this article, Tom Ellison takes you through the steps to get the correct
conversion rate from a table:
Lookup in a range of values in a query
at:
http://allenbrowne.com/ser-58.html