creating a calculated field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 

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

Back
Top