About
Pricing
Community
Teams
Start Free Trial
Log in
bill201
asked on
12/23/2012
how to format a value in a query in access to a different curreny symbol
i want to get in a access query a currency value with another currency symbol and not the windows default. is that possible?
this is my code: Format(total,"Currency") AS TotalEx
if is not possible is there some way to add a word to a num value (visualy) like 100 with the word "euro"
Databases
Microsoft Access
SQL
12
5
Last Comment
bill201
8/22/2022 - Mon
SOLUTION
jerryb30
12/23/2012
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
jerryb30
12/23/2012
Can you not....
bill201
12/23/2012
ASKER
thanks alot for your answer
i will be more specific i dont need a euro symbol (it's was an example) i need a Shekel symbol
like there
http://en.wikipedia.org/wiki/Shekel_sign
where can i put this
format ([price],"shekel Symbol")
SOLUTION
Vinicio Guzman
12/23/2012
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
bill201
12/24/2012
ASKER
but i want that it's will be a number value and not a text string
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
SOLUTION
Gustav Brock
12/24/2012
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
bill201
12/24/2012
ASKER
its not possible that the char will just be a format visualy?
SOLUTION
Patrick Matthews
12/24/2012
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
Gustav Brock
12/24/2012
Yes, then you would use the Format property:
\€#,##0.00
Replace € with your Sekel sign (the font here seems not to hold it).
/gustav
Patrick Matthews
12/24/2012
That was supposed to be a shekel symbol, but it would not post. The sample file uses the symbol correctly.
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
ASKER CERTIFIED SOLUTION
jyk_aus
12/24/2012
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
bill201
12/24/2012
ASKER
thanks alot for every one