 |  |  |  |  |  |  |  |
How to set precision to the left of decimal?
Please support our MS Access and FileMaker Pro advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
 |
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
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
Defeat the defeat before the defeat defeats you
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.
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.
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
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
Defeat the defeat before the defeat defeats you
Hi,
I have attached u a DB with one table to check it, if I wrongly understood you please clarify.
I have attached u a DB with one table to check it, if I wrongly understood you please clarify.
It is never about the number of languages you know, you either have the logic of programming or you don't ...
Some of the codes I post are collected from different sites during the past couple of years, so I would like to thank them for their help and for enabling me to help.
Some of the codes I post are collected from different sites during the past couple of years, so I would like to thank them for their help and for enabling me to help.
|
Similar Threads
- define variable (C)
- Microsoft Access 2003 Validation Rule (MS Access and FileMaker Pro)
- MS Access validation rule help (MS Access and FileMaker Pro)
- Trouble with printing to a file (C)
- Double values with two decimal places (C++)
- Right Justified / decimal point alignment (C)
- Floating point numbers (C++)
- Set Precision in C++.NET? (C++)
Other Threads in the MS Access and FileMaker Pro Forum
- Previous Thread: MS Access parameter querry criteria Help?
- Next Thread: IIf statement help
| Thread Tools | Search this Thread |
Latest MS Access and FileMaker Pro Posts
- Today's Posts
- Unanswered Threads
Related Forum Features
Tag cloud for MS Access and FileMaker Pro
