Results 1 to 8 of 8
  1. #1
    azhar2006's Avatar
    azhar2006 is offline Expert
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2012
    Posts
    528

    Several The types of currency

    Good day all.
    I want to change the currency symbol! I only get the dollar sign $
    I would like to change it ot the Euro Symbol € how do i get this done ?


    Meaning I want Several the types to currency in database
    Thanks in advance

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    Then you can't, access only allows 1 currency symbol.
    To work around, you'd have to have a tCountry table, with each currency symbol..(I do).
    then when you display the given curr field, format it without the symbol, format([fld],"0.00")
    While appending the correct symbol from the tCountry table.

  3. #3
    azhar2006's Avatar
    azhar2006 is offline Expert
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2012
    Posts
    528
    Thank you very much ranman256
    I will try to work on it. But you want to get an example.
    Thanks again

  4. #4
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    In your query, you would join it to the tCountry table. It has the CurrSym.
    the result would be:
    MyField: [tCountry].[CurrSym] & format([MonyAmt],"0,000.00")

  5. #5
    twgonder is offline Expert
    Windows 10 Access 2016
    Join Date
    Jun 2022
    Location
    Colombia
    Posts
    652
    Create a currency table, don't put it in country. Some countries use the currency of a "parent" region (Euro) or of another (Ecuador).
    Then you can add the "primary" currency to the country table if you wish. Or, you can go nuts and create a table of all the currencies used in the country (Venezuela).

    Click image for larger version. 

Name:	Currency5.jpg 
Views:	21 
Size:	45.4 KB 
ID:	48206

  6. #6
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,529
    @twgonder
    You may not have realized it, but the thread you posted to was over six years old. The OP is probably no longer following this link.

    Alan

  7. #7
    twgonder is offline Expert
    Windows 10 Access 2016
    Join Date
    Jun 2022
    Location
    Colombia
    Posts
    652
    Thanks Alan, but someone else, new to the Forum like me, might stumble upon this thread.

  8. #8
    Micron is online now Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    If I think I have a solution worth posting and the thread is old, I try to remember to acknowledge its age when doing so. Then there's no need for anyone to point that out. The thread might show up in search engine results if it's a close match for the search and that would be good. However, like Alan I sometimes point out the age of a thread; especially if the late post contains things like questions.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. different types of currencies
    By tommyried in forum Forms
    Replies: 3
    Last Post: 03-02-2014, 02:18 AM
  2. Field Types
    By ccordner in forum Access
    Replies: 2
    Last Post: 12-13-2011, 12:33 PM
  3. Replies: 7
    Last Post: 10-25-2011, 08:32 PM
  4. Replies: 2
    Last Post: 03-23-2011, 11:43 AM
  5. Memo Data Types
    By Joanne Searcy in forum Database Design
    Replies: 4
    Last Post: 12-28-2010, 08:04 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums