How do I change $ into £?

T

tinkerbelle

Is it possible for me to change a value which is in american dollars into
british pounds? How do I do this? E.g. a conversion between the two
currencies to create one price in british pounds.
 
F

FSt1

hi,
this is a simple math problem. Pounds = Dollars times converion rate.
Since you posted in querries, i assume you want to do this with a query.
but i need more info to say more. where are you getting your data(dollars)?
the conversion rate changes often so you will have to get that from the web
like
x-rate.com or similar plug in into a form or table.

regards
FSt1
 
T

tinkerbelle

I put it in queries because that where I thought it should be.

I don't want the amount to change all the time. What it is, I order items
from the USA or elsewhere and sell them in the UK so I need the amounts to be
in GBP to know how much I need to charge. The exchange rate I need to use is
whatever it was at the time of ordering which I can manually imput if
necessary. I get the US dollar amount from the invoice I recieve and
currently manually enter this amount each time I create a new record.

I hope this helps you to know what I need.
 
F

FSt1

hi,
yes it is helpful.
In your query, in a query header try this

GBP:[Dollarsfield]*[ConverionsRateField]

I don't know the names of your fields so you will have to adjust.
this will create a new column in your query showing $ in GBP. if you don't
have a value in the conversion rate field, the query will so a blank(null).

regards
FSt1
 
Top