Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2006
    Posts
    11

    Question Unanswered: currency exchange into one table

    hello ,I am using MS Access 2003 . New user and trying to build an IS that will serve my new business of Advertisment agency .
    I created some tables as standared for customers etc ..
    But i was thinking about the currency change factor for the campign .
    As there are three payments alternatives
    1- US Dollars
    2-Euro
    3-British Pound
    So , i wish that some one may kindly update me how can i perform this in the campgin table .
    Thanks
    may you help me please ?
    Last edited by mmortaga; 04-08-06 at 15:57.

  2. #2
    Join Date
    Apr 2004
    Location
    outside the rim
    Posts
    1,011
    I suggest choosing a standard currency and putting all your campaings in it.

    Create a seperate table of currency conversion factors (since they change often anyway) against your standard currency.

    Then, you have some options:
    - In your queries, you can add fields that calculate the cost in each currency.
    - On your forms, you can have the standard currency on a hidden control and have a visible control that displays the cost calculated in the currency selected by the user.
    - You can combine the above two options by having a field in your table that stores key of the default currency for the particular campaign (still store the cost in the standard currency) and let the form and query do there jobs.

    hope this helps,
    tc

  3. #3
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    I think you would be best to store you currency types in a separapet table,
    and store thevlaues inside the applciable row

    eg
    BaseCur
    BaseCureVal
    ForexCur
    ForexVal

    if you are not UK based then you will probably be able to say what you currency is and be confident it will remain that currency for the life of the project.

    the reason in my mind is that each transaction will be a different forex rate, theoretically the forex rate can go up and down like a fiddlers elbow each and every day. So storing a forex rate in a separate table makes no sense.

    by moving the currency to a separate table you can add or remove currencies as the businees need changes

    you have visibility of what the customer has actually spent bith in "their" currency and "your" currency. compartives are realtively easily done, you could look at the value of transactions over time in either currency.

    its arguable that you could use a forex rate, rather than forex value, thats up to you. I would suggest however thast you store as a true value.

    HTH
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •