From Mike Chapple,
Your Guide to Databases.
FREE Newsletter. Sign Up Now!

Function: EuroConvert()

Purpose: The EuroConvert() function converts a European currency value to or from Euros, using the European Union's fixed conversion rate.

Usage: EuroConvert(value, source, target)

Value is the currency value (as a number) that you wish to convert.
Source is the currency that you wish to convert from. Value is in this currency. The variable should be a string from the table below.
Target is the currency that you wish to convert to. The variable should be a string from the table below.

Returns: Currency value in target currency.

Examples and Special Cases

Convert 10 Euros to French francs:
EuroConvert(10, "EUR", "FRF")

Convert 25 Italian lira to Euros:
EuroConvert(25, "IRL", "EUR")