Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now
Course Of The Month
10 days, 13 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
how to format a value in a query in access to a different curreny symbol
Posted on 2012-12-23
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"
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
-
4
2
2- +3
12 Comments
Cab you not format the field as currency/euro in table design?
Otherwise, look here:
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_21695968.html
Otherwise, look here:
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_21695968.html
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")
Active today
If you concatenate a char and a number you will get a string.
If you also need the numerice value, have two columns.
/gustav
If you also need the numerice value, have two columns.
/gustav
Active today
In your table design, select that column, and in Format for the column properties use something like this:
¿#,##0.00;(¿#,##0.00)
It worked for me.
Q-27976657.mdb
¿#,##0.00;(¿#,##0.00)
It worked for me.
Q-27976657.mdb
Active today
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
Active today
That was supposed to be a shekel symbol, but it would not post. The sample file uses the symbol correctly.
I use multiple currencies, including the shekel regularly.
The way I approach this particularly problem is by having a 'Currencies' table that holds the currencies signs amongst other thing - the *minimum* you would need is:
[Currency_ID] = PK
[Currency Name]
[Currency ISO] (eg USD, ILS, EUR etc), Required, zero length not allowed
[Currency Symbol] - not required as some currencies don't have a specific symbol or I dont have symbols for such currencies.
All these fields are Indexed, duplications not allowed - you may allow duplication in the symbol but I would not recommend it.
If you are using more than one currency that uses the dollar sign and you allow duplications it is still a good practice to distinguish beteen them by using US$, A$, C$, NZ$ etc as symbol, the same gors for the franc sign, if you are using it.
I have a public function, say CurrencySymbol(), that extrct the symbol using the DLookup() and if it returns Null for the symbol it uses the [Currency ISO] as an alternative, e.g.
++++++++
Public Function CurrencySymbol( _
idCurrency As Long) _
As String
Dim tmpSymbol As Variant, tmpCode As String
tmpSymbol = DLookup("[Currency Symbol]", "Currencies", "[Currency_ID]=" _
& idCurrency)
tmpCode = Nz(DLookup("[ISO Code]", "Currencies", "[Currency_ID]=" _
& idCurrency), "")
CurrencySymbol = IIf(IsNull(tmpSymbol) Or Len(CStr(tmpSymbol)) = 0, tmpCode, _
CStr(tmpSymbol))
End Function
+++++++++
In order to display the currency symbol in a query, I link the query to the currency table on [Currency_ID] and the rest is simple:
YourField=CurrencySymbol([
Note: This assumes that *all* the currencies that you are using are sub-divisible by 100 (e.g 100 cents in a dollar, 100 agorot in a Skekel etc), if this is not the case, such as in Yen and some other currencies, the query is slightly more compleicated if you wish to eliminate the decimal for such currencies.
I hope that this is helpful
Best regards
Jacob
The way I approach this particularly problem is by having a 'Currencies' table that holds the currencies signs amongst other thing - the *minimum* you would need is:
[Currency_ID] = PK
[Currency Name]
[Currency ISO] (eg USD, ILS, EUR etc), Required, zero length not allowed
[Currency Symbol] - not required as some currencies don't have a specific symbol or I dont have symbols for such currencies.
All these fields are Indexed, duplications not allowed - you may allow duplication in the symbol but I would not recommend it.
If you are using more than one currency that uses the dollar sign and you allow duplications it is still a good practice to distinguish beteen them by using US$, A$, C$, NZ$ etc as symbol, the same gors for the franc sign, if you are using it.
I have a public function, say CurrencySymbol(), that extrct the symbol using the DLookup() and if it returns Null for the symbol it uses the [Currency ISO] as an alternative, e.g.
++++++++
Public Function CurrencySymbol( _
idCurrency As Long) _
As String
Dim tmpSymbol As Variant, tmpCode As String
tmpSymbol = DLookup("[Currency Symbol]", "Currencies", "[Currency_ID]=" _
& idCurrency)
tmpCode = Nz(DLookup("[ISO Code]", "Currencies", "[Currency_ID]=" _
& idCurrency), "")
CurrencySymbol = IIf(IsNull(tmpSymbol) Or Len(CStr(tmpSymbol)) = 0, tmpCode, _
CStr(tmpSymbol))
End Function
+++++++++
In order to display the currency symbol in a query, I link the query to the currency table on [Currency_ID] and the rest is simple:
YourField=CurrencySymbol([
Note: This assumes that *all* the currencies that you are using are sub-divisible by 100 (e.g 100 cents in a dollar, 100 agorot in a Skekel etc), if this is not the case, such as in Yen and some other currencies, the query is slightly more compleicated if you wish to eliminate the decimal for such currencies.
I hope that this is helpful
Best regards
Jacob
Featured Post
We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Recently I was talking with Tim Sharp, one of my colleagues from our Technical Account Manager team about MongoDB’s scalability. While doing some quick training with some of the Percona team, Tim brought something to my attention...
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks.
Specify a start-up form through options:
Specify an Autoexec macro:
Us…
Suggested Courses
Earn Certification
HTML5 Specialist - Certification
Free withPremium
Course of the Month10 days, 13 hours left to enroll
628 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.