View Single Post
Old 07-15-2019, 04:02 AM   #9
gemma-the-husky
Super Moderator
 
gemma-the-husky's Avatar
 
Join Date: Sep 2006
Location: UK
Posts: 13,768
Thanks: 55
Thanked 1,022 Times in 988 Posts
gemma-the-husky is a name known to all gemma-the-husky is a name known to all gemma-the-husky is a name known to all gemma-the-husky is a name known to all gemma-the-husky is a name known to all gemma-the-husky is a name known to all
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.
__________________
Dave (Male!)
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.
gemma-the-husky is offline   Reply With Quote