creating a calculated field

K

kieran

I am trying to create a column in an accesss query or report that will let us
convert different values to one currency.In the underlying table columns
exist showing a currency code and a base fare. I need to be able to convert
all the base fares to one currency in order to calculate an average by flight
number.

thanks.
 
G

Guest

hi,
need more info.
is the currency code the conversion multplier?
if not what/where is sthe conversion multplier?
to do this you will need
oldcurrency x conversion multiplier = new currencey.
 
Top