Convert ro Euro currency

[Guest]

I have used Ccur to convert data type to currency which puts the local
currency sign (in my case £) before the value. Is it possible or is there a
convertion function which will include the Euro (€) symbol instead of the £
symbol without changing the local setting for the PC.

Thanks

 

[Guest]

Hi,
Check the EuroConvert function.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbaac10/html/acfctEuroConvert.asp

You could then use:

="€" & EuroConvert(100,"GBP","EUR")

To get the EUR sign just hold down ALT and press 0128 on the num pad. Access
should also store this.
HTH
Good luck

 

[Guest]

Thanks for the information Oliver, this does help me in one aspect however,
I'm not sure I have explained myself clearly enough.

I have a query similar to:

iif([field1]>[field2],[field3],field4])

Field3 and 4 iare both stored as decimal and as such displays as 34.56.

If I use Ccur, I can get the display to show £34.56 but I need to display
€34.56.

I have tried using "€"&[field4] but this prevents me carrying out other
functions at a later time.

 

[Guest]

Hi,
well don't do it in the query.
Since you shouldn't display query results directly to the user anyway, but
rather through an interface of either forms/reports just format the finished
calculated values on forms or reports as shown. Instead of handling the
values as currency just leave them as numbers and do your calculation...it
doens't really matter to you how access stores it until you need to see it on
a form.
HTH
Good luck
--
Oliver
Admin Specialist & Computer Science Major @ UMD - Go Terps -
http://www.oli-s.de

Thanks for the information Oliver, this does help me in one aspect however,
I'm not sure I have explained myself clearly enough.

I have a query similar to:

iif([field1]>[field2],[field3],field4])

Field3 and 4 iare both stored as decimal and as such displays as 34.56.

If I use Ccur, I can get the display to show £34.56 but I need to display
€34.56.

I have tried using "€"&[field4] but this prevents me carrying out other
functions at a later time.

Hi,
Check the EuroConvert function.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbaac10/html/acfctEuroConvert.asp

You could then use:

="€" & EuroConvert(100,"GBP","EUR")

To get the EUR sign just hold down ALT and press 0128 on the num pad. Access
should also store this.
HTH
Good luck

 

[John Nurick]

You could then use:

="€" & EuroConvert(100,"GBP","EUR")

Did it work when you tried it?

EuroConvert() was introduced to simplify the euro transition. It seems
to embody the official exchange rates and algorithms for conversions to
and from the euro and the participating currencies - which don't include
GBP.

 

[Guest]

this is a direct quote from msdn:

Later versions of the EuroConvert function may support additional
currencies. For information about new participating currencies and updates to
the EuroConvert function, see the Microsoft Office Euro Currency Web site.

Pound sterling is one of these.
The function however will not format the value as a euro currency value
(with EUR symbol) since this is based on the regional settings of windows.
That's why storing the value just as a numeric value to do calculations and
then formatting them at runtime on reports/forms with the euro symbol should
work.
Reading back over the OPs initial question I think he doesn't actually not
to convert the value from pounds to euro, but rather just change the sign of
it.

 

[Brendan Reynolds]

this is a direct quote from msdn:

Later versions of the EuroConvert function may support additional
currencies. For information about new participating currencies and updates
to
the EuroConvert function, see the Microsoft Office Euro Currency Web site.

Pound sterling is one of these.

I'm sorry, Oliver, but that last statement is incorrect. Sterling is not and
never has been a participating currency. In fact, there are at present no
participating currencies - the transition period is over, and all of the
participating currencies have therefore ceased to exist. The EuroConvert
function is now only appropriate for use with historical data from the
transition period.

 

[Guest]

Then the MSDN article seems to be either incorrect or outdated.
Thanks for clarifying the current situation concerning the EuroConvert
function.
Either way...as I mentioned I think the OP doesn't really need to convert
the values anyway, but rather change the signs. If not then he obviously
could achieve that just with some simple math.
Thanks again.

 

[Brendan Reynolds]

Rather than using CCur in the expression, set the Format property of the
query column to Euro.

Open the query in design view.

Select the column you want to format.

If the Field Properties window is not already visible, select Properties
from the View menu
..
Make sure the title bar of the Properties window says 'Field Properties' not
'Query Properties'. If it says 'Query Properties', the column is not
selected.

The Format property is the second item on the General tab.

--
Brendan Reynolds
Access MVP

Thanks for the information Oliver, this does help me in one aspect
however,
I'm not sure I have explained myself clearly enough.

I have a query similar to:

iif([field1]>[field2],[field3],field4])

Field3 and 4 iare both stored as decimal and as such displays as 34.56.

If I use Ccur, I can get the display to show £34.56 but I need to display
?34.56.

I have tried using "?"&[field4] but this prevents me carrying out other
functions at a later time.

Hi,
Check the EuroConvert function.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbaac10/html/acfctEuroConvert.asp

You could then use:

="?" & EuroConvert(100,"GBP","EUR")

To get the EUR sign just hold down ALT and press 0128 on the num pad.
Access
should also store this.
HTH
Good luck

 

[Guest]

Thanks for all your replies. I have managed to achieve what I needed to by
using the following expression in the query. I needed to have the forrect
format in the query, although technically a query isn't normally used to view
the final data, as I needed the facility to copy and paste into Excel in the
correct format.

Expression used to convert currency into Euro:

Expr1: Format([whateverfield],"€#.00")

This ensured that the value was prefixed with the Euro sign and displayed to
2 decimal places and could be sorted numerically.

Once again, many thanks for all your replies.

DAve1.