View Single Post
Old 07-11-2019, 11:03 PM   #6
Cark
Newly Registered User
 
Join Date: Dec 2016
Posts: 95
Thanks: 47
Thanked 1 Time in 1 Post
Cark is on a distinguished road
Re: Forcing A Field's Data Type To Be Currency In Dollars ($) Instead Of Regional Set

Just to clarify, all costs will be entered into the database in $, so having data with ús will not be necessary in this particular database.

If I understand the suggestions correctly, I would be best keeping the Cost column in my database as numerical values e.g 2530.52 (which realistically would represent $2530.52) and then use formatting to change these values whenever I use the values in a Form or in an Export?
Cark is offline   Reply With Quote