944,072 Members | Top Members by Rank

Ad:
Aug 27th, 2007
0

How to set precision to the left of decimal?

Expand Post »
hi all!
I need to set precision to the left of decimal. For the number field i have to set the field precision such that the nos should be in a format as 0001,0002,0003------------------.9999.
Thanks
Similar Threads
Reputation Points: 10
Solved Threads: 0
Newbie Poster
elanch is offline Offline
23 posts
since Jul 2007
Aug 27th, 2007
0

Re: How to set precision to the left of decimal?

Hi,

In the design view select the field and in the format property (in the lower part of the table design view) put 0000. This will show the number 1 as 0001 or 888 as 0888 noting that it is a matter of just format that means the number will actually stay 1 or 88.
Reputation Points: 13
Solved Threads: 29
Junior Poster
kb.net is offline Offline
169 posts
since Aug 2007
Aug 28th, 2007
0

Re: How to set precision to the left of decimal?

hi friend!
Thank u for u'r reply. I have tried your suggestion. But it is not working. when i enter a single digit no, the format is not changing.plz give me any other idea to do it.
thanks
Reputation Points: 10
Solved Threads: 0
Newbie Poster
elanch is offline Offline
23 posts
since Jul 2007
Aug 28th, 2007
0

Re: How to set precision to the left of decimal?

Hi,
I have attached u a DB with one table to check it, if I wrongly understood you please clarify.
Attached Files
File Type: zip Sample.zip (7.1 KB, 46 views)
Reputation Points: 13
Solved Threads: 29
Junior Poster
kb.net is offline Offline
169 posts
since Aug 2007

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in MS Access and FileMaker Pro Forum Timeline: MS Access parameter querry criteria Help?
Next Thread in MS Access and FileMaker Pro Forum Timeline: IIf statement help





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC