Results 1 to 2 of 2
2007-09-25, 19:40 #1
- Join Date
- Apr 2001
- Guatemala City
- Thanked 0 Times in 0 Posts
Various currencies in same DB (Win XP Access 2003)
I receive a Purchase Order with various line items. Each PO may be in, currently, one of two currencies. At some point it is expected that there will be more currencies.
Each line item should be controlled in it’s currency – different format for printing and in forms, different totals for statistics, different totals for A/R, and so on.
The PO has a field that denotes the currency to be used.
The mathematic is no problem A sum is a sum, and there are no requirements of converting from one currency to another.
Any ideas to get me started?
2007-09-25, 19:54 #2
- Join Date
- Mar 2002
- Thanked 29 Times in 29 Posts
Re: Various currencies in same DB (Win XP Access 2003)
You could simply place the text box or combo box bound to the field that defines the currency in front of the text box with the amount.
Or in a report, you can use the On Format event of the detail section to set the Format property of the amount text box to the appropriate format for the currency.
What else did you want to know?