Convert Currency to another currency amount

[AlaaB]

Good Day Guys,
i have a lite critical issues here and i need you support

1st i have a table contain lots of accounts
i register the amount each time wiht a diffrent type of currency such as (US dollar,euro etc,,,
and the point is that i want to give the final statement and all the currency converted to US Dollar,

2nd i need to make the dollar has a different currency each month, which means that i have to enter the currency of the dollar and the query or the module will covert the whole currency to US Dollar in a new filed


so could any body help me please
waiting your kind reply


Alaa

 

[Steve R.]

Multiple-Post.

 

[AlaaB]

no it's not a Multiple-Post
but it has a 2 ways of answer and i need to know one of them
Thanks in advanced

 

[JohnPapa]

It seems that you are dealing with Foreign Exchange of some sort. What you are asking is fairly straightforward as long as you take care of the decimal places in Single numbers (7 decimal places) or Double (15 decimal places) and not let Access automatically hold 7 or 15 decimal places.

I am not clear what you want to do? Are you having specific problems or you want someone to guide you through the process?

 

[AlaaB]

yes man,

the problem is that am treating with 3 type of currency such as Dollar Euros etc
and each record has its value as example I have bout stationary for the admin office with 100 euro
and the second record has a canteen expense with 150.50 $
so, what I need to do is

have all the currency converted to us dollar for ex.
The first record should be 100 Euros *”( Dollar exchange)”45.5 = 4550
The second one should be 150.50 *1 because it’s already Dollar

So I need them to store in a new field at the same table called $ Exchange

And I need to take the dollar exchange amount from another table called $ exchange which has the date and the dollar exchange amount

 

[JohnPapa]

I need more info.

If you deal with invoices in different currencies then you need to be consistent when it comes to accounting. Currency rates change all the time, so a good question to answer is " What is the meaning of a conversion of say EUR to USD at a specific rate?" If you do the convesrion a few seconds later, you will find a different value.

To proceed you need a proper functional spec. If you have this I can assist.

 

[AlaaB]

ok, i'll give u more info
at the company we'll take only rate of the exchange at the 1st of the month and use it as a standard
therefore i made a new table contain the exchange of the dollar and the month

wish it's clear now
and thanks for being interested man

 

[JohnPapa]

There are still many unanswered questions, but with what you have provided:
1) You have certain values in non-USD that on the 1st of the month need to be reported in USD and the conversion is done using a specific exchange rate.
2) Once the conversion is made you need a mechanism to freeze the converted values so that they do not change. Depending on the number of conversions and the people that need to be able to simultaneously access the valuew, you can leave the values, say in EUR, and do the conversion on the fly (as needed). In this case you need to hold the exchange rate somewhere safe and away from people who can change them. It is probably safer to change the EYR amounts to USD and work on the USD. In this case you need to freeze the initial EUR amounts so that you can investigate any queries.
3) Most importantly, in Access Singles are stored with 7 decemal places and Doubles with 15 decimal places. You probably need 2 decimal places so when you multiply a EUR amount by the exchange rate, if you need to make sure that the result is kept to 2 decimal places, you need to multiply by 100, round, and then divide by 100:
Int(100 * [PositiveYourField]) / 100
For negative numbers use
Fix(100 * [NegativeYourField]) / 100

These are just a few issues to take care of. I will repeat that you need a detailed functional specification prior to doing any coding.

 

[AlaaB]

ok man
actually i feel like u miss understand me very well cause in fact i didn't give u all the requested info ( maby am not able to convert my ideas )
so could you please send me your mail and i'll send u the data and u'll check it and give me your opinion and your advice and support
and i'll be gratfullllllllll man

thanks in advanced


Alaa

 

[JohnPapa]

Please send zipped files to John@KosmosBusiness.com.