Forum home » Delegate support and help forum » Microsoft Access Training and help » Access
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access
Resolved · Low Priority · Version 2003
Reply Wed 18 Jun 2008, 16:41Delegate Tp said...
Tp has attended:
Access Introduction course
Access
What is the best way of handling multi-currency transactions in Access?
For upcoming training course dates see: Pricing & availability
Reply Sat 5 Jul 2008, 23:40Delegate Mark said...
RE: Access
Hello TP,
It sounds like you will need a field which designates the currency type against each currency entry. I would suggest having a look-up table to store the currency types by name and symbol, ie a field for each of these two within the look-up table. Then a third field in this table could be for conversion rates. If you need to keep the conversion rate that applied at a particular date and time (eg for a transaction or sale etc) then you will need for the conversion rate to store against each such record--by having a field in the table that stores details of such transactions). If you do enter conversion rates in to a form you set up for the purpose then you can have date and time against your entry to go in automatically by having and additional time field with a default value of Now()
If you need a reminder on how set up a look-up just reply so and I (or someone) will reply again.
Regards, Mark
|