Re: Forcing A Field's Data Type To Be Currency In Dollars ($) Instead Of Regional Set
I would use currency. It's just a column of numbers. You can format it for display with a dollar symbol, or with no symbol.
The only issue would be if you weren't happy with the accuracy of the pounds/pence, euro/cents, dollar/cents conversions, but you are only talking about fractions of a penny at 4 significant dps.
Gemma was my dog
if a poster helps you, please click the scales at the bottom left of this posting, or use the thanks button alongside.