Currency conversions
Currency conversions
(OP)
hi
looking to do currency conversions in the database. What I want to do is to have a separate currency table which then, depending on which currency is selected in the main database, converts the input data into local currency.
In other rdb's or excel I would use another data table or a vlookup function. How do I do it in Approach?
Any ideas welcome.
thanks
Charles
looking to do currency conversions in the database. What I want to do is to have a separate currency table which then, depending on which currency is selected in the main database, converts the input data into local currency.
In other rdb's or excel I would use another data table or a vlookup function. How do I do it in Approach?
Any ideas welcome.
thanks
Charles
RE: Currency conversions
When you put the incoming currency type in the data entry field, the conversion factor will instantly become available for use in calculated fields, macro SET statements, etc. You would probably run a macro on "data change" of the currency amount being entered. This macro would SET the local currency field in your data entry table.
Sue Sloan
RE: Currency conversions
thanks again for your help
Charles