asked on
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"
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"
DatabasesMicrosoft AccessSQL
Last Comment
bill201
SOLUTION
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.
Can you not....
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")
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
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.
ASKER
but i want that it's will be a number value and not a text string
SOLUTION
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.
ASKER
its not possible that the char will just be a format visualy?
SOLUTION
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.
Yes, then you would use the Format property:
\€#,##0.00
Replace € with your Sekel sign (the font here seems not to hold it).
/gustav
\€#,##0.00
Replace € with your Sekel sign (the font here seems not to hold it).
/gustav
That was supposed to be a shekel symbol, but it would not post. The sample file uses the symbol correctly.
ASKER CERTIFIED SOLUTION
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.
ASKER
thanks alot for every one