MS Access data conversion

Author

conversion

treva wandrei

2005-07-01, 7:24 am

How can i convert euro to $?

treva.wandrei@livepharm.com

Chris Mills

2005-07-03, 3:24 am

Microsoft Access, F1(Help), type in "Euro".
(seems to return Euro symbols)

Microsoft Access, VBA code module, F1(Help), type in "Euro"
(EuroConvert Function)

It seems to me amazing that in-built Access handles ANY type of currency
conversion!
(presumably the Euro is fixed to other European currencies, unlike "the real
world!"
Chris

P.S. What $?

"treva wandrei" <treva.wandrei@livepharm.com> wrote in message
news:114f1$42c510b8$
d99c5301$28136@allth
enewsgroups.com...
> How can i convert euro to $?
>
> treva.wandrei@livepharm.com

John Nurick

2005-07-03, 1:23 pm

To convert between € (euro/EUR) and $ (dollars/USD) you need to find the
appropriate exchange rate (e.g. financial page of newspaper or
http://www.oanda.com). After that it's just a matter of arithmetic.

The EuroConvert() function is for use in the transition between national
currencies and the euro. During the transition period, the exchange rate
and algorithm for conversion between each national currency (e.g. the
French franc FRF) and the euro were fixed by law.

Since there are now no currencies undergoing transition, EuroConvert()
is now of mainly historical interest. If in future more EU member states
join the single currency, Microsoft will need to update EuroConvert() to
make it useful again.

On Sun, 3 Jul 2005 20:13:44 +1200, "Chris Mills"
< phad_nospam@cleardot
net.nz> wrote:

>Microsoft Access, F1(Help), type in "Euro".
>(seems to return Euro symbols)
>
>Microsoft Access, VBA code module, F1(Help), type in "Euro"
>(EuroConvert Function)
>
>It seems to me amazing that in-built Access handles ANY type of currency
>conversion!
>(presumably the Euro is fixed to other European currencies, unlike "the real
>world!"
>Chris
>
>P.S. What $?
>
>"treva wandrei" <treva.wandrei@livepharm.com> wrote in message
> news:114f1$42c510b8$
d99c5301$28136@allth
enewsgroups.com...
>

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.

Chris Mills

2005-07-05, 3:24 am

> Since there are now no currencies undergoing transition, EuroConvert()
> is now of mainly historical interest.

Probably right, John, and certainly any conversion within MS-Access must
involve fixed parameters "legislation".

I did note, as a minor point, that those "damn Brits" (and everyone else
European) continues to advertise (on the internet) in their well-loved local
"pounds" or "liras" or whatever.

Maybe that's like you yanks should have converted to metric screws a long time
ago <GUFFAW>

You made a very good point (at least as I saw it). Maybe it's possible to
auto-download some exchange rate from some site, since obviously most vary
daily. I've never had reason, but clearly that would be the way to go -
automate exchange rates by some download!

Chris

PS When I look at prices, I still think of pounds (for UK, say). I STILL have
not the foggiest notion what a Euro actually weighs. Of course, neither am I
in Europe. Of course, I am also old and set in my "units"! But I CAN handle
inches simultaneous with millimeter threads, until you yanks tow-the-line that
is <g>

Brendan Reynolds

2005-07-05, 7:24 am

The UK has not adopted the Euro, but you should not, as far as I know, be
seeing prices advertised in Lira in any current web site - unless there are
countries other than Italy that call their currency the Lira?

http://europa.eu.int/comm/economy_f...currency_en.htm

--
Brendan Reynolds (MVP)

"Chris Mills" < phad_nospam@cleardot
net.nz> wrote in message
news:ebgcbbQgFHA.1048@tk2msftngp13.phx.gbl...
>
> Probably right, John, and certainly any conversion within MS-Access must
> involve fixed parameters "legislation".
>
> I did note, as a minor point, that those "damn Brits" (and everyone else
> European) continues to advertise (on the internet) in their well-loved
> local
> "pounds" or "liras" or whatever.
>
> Maybe that's like you yanks should have converted to metric screws a long
> time
> ago <GUFFAW>
>
> You made a very good point (at least as I saw it). Maybe it's possible to
> auto-download some exchange rate from some site, since obviously most vary
> daily. I've never had reason, but clearly that would be the way to go -
> automate exchange rates by some download!
>
> Chris
>
> PS When I look at prices, I still think of pounds (for UK, say). I STILL
> have
> not the foggiest notion what a Euro actually weighs. Of course, neither am
> I
> in Europe. Of course, I am also old and set in my "units"! But I CAN
> handle
> inches simultaneous with millimeter threads, until you yanks tow-the-line
> that
> is <g>
>
>

Chris Mills

2005-07-05, 7:24 am

> The UK has not adopted the Euro,

You're kidding me, Brendan?
No, you wouldn't make "Irish jokes".

> but you should not, as far as I know, be
> seeing prices advertised in Lira

Lira was just "filling". I referred mainly to "Pounds" coz I have visited UK
several times, and have a vague heritage there (grandma, I also lived in
London for 2yrs)(also toured Ireland Nth & Sth). Well, not in the last 20
years except via internet.

So. Where is Ireland in all this? I thought they were part of the Euro, Potato
Famine notwithstanding.

I DO take an interest, Brendan, I see from your posted URL that Ireland is
listed in the Euro and UK is not. Not being in or especially associated with
Europe, clearly I can learn a lot, Thanks!

> http://europa.eu.int/comm/economy_f...currency_en.htm
>
Regards,
Chris

Sponsored Links