By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,145 Members | 1,550 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,145 IT Pros & Developers. It's quick & easy.

Converting currency

P: n/a
Jon
I have a field called "Amount". In it, there may be values populated that
are either in or $.

I want another field, called "ConvertedAmount" that will store the value in
dollars. If Amount field shows $ or , it needs to do a calculation to store
the correct value in the ConvertedAmount field, always in $.

Make sense? If so, how!

Jon
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
you don't need to store the 'convertedAmount'
you need, in your existing table
amount
currencyId
transactionDate

tblCurrency
currencyId pk
exchangeRate
effectiveDate

then you need a function that takes calculates the converted (home) amount
given amount, currencyId and date as parameters
"Jon" <da***********@hotmail.com> wrote in message news:<40***********************@lovejoy.zen.co.uk> ...
I have a field called "Amount". In it, there may be values populated that
are either in or $.

I want another field, called "ConvertedAmount" that will store the value in
dollars. If Amount field shows $ or , it needs to do a calculation to store
the correct value in the ConvertedAmount field, always in $.

Make sense? If so, how!

Jon

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.