Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Decimal place

Status
Not open for further replies.
Krash878

Krash878

Programmer
May 8, 2001
172
US
I need a decimal in currency format to moce to the left two spaces.

1234 = $12.34
5000 = $50.00
and so on
Is a property for this or maybe some code
Thanks
Ken
 
Sort by date Sort by votes
You can go to the table's design view and put the following in the field's format property section...

$0\.00

This will make 1234 = $12.34 for existing records. It will also take care of future entries that come in as 9999 so they appear as $99.99. ljprodev@yahoo.com
ProDev
MS Access Applications
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

DevelopV
  • Locked
  • Question
Union query - place data into an imaginary field 1
Replies
5
Views
76
PHV
PHV
jpl458
  • Locked
  • Question
Constraining query on decimal field 4
Replies
11
Views
48
lameid
lameid
NWildblood
  • Locked
  • Question
Access SQL String to Numeric - not returning data after decimal point, not changing data type 1
Replies
10
Views
162
NWildblood
NWildblood
THWatson
  • Locked
  • Question
Convert Percentage into decimal in Microsoft Access query 1
Replies
8
Views
362
THWatson
THWatson
Twinmammy
  • Locked
  • Question
losing decimal when loading to MS access
Replies
9
Views
126
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top