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