i want to increase numeric field length

M

murtaza

i want to increase numeric field length upto 15 number for egs.. pls tell me how i can do that
 
J

John Vinson

i want to increase numeric field length upto 15 number for egs.. pls tell me how i can do that
Click to expand...

Use a Double. That's *just barely* fifteen decimals.

If you have AccessXP or later, you can use a Decimal datatype but be
aware that its implementation appears to have some bugs (sorting
incorrectly for example).

Neither Integer, Long Integer, Single or Currency will do the job.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MS Project. Real progress of the project, % complete 1
Header Roman Numeral to Regular Numbers 1
Space at end of multi page list to accommodate new entries 1
frame around the text and row numeration 1
Remove title bar and phase bar by default on swimlane 0
Data validation, mandatory and restricted field length for excel vbs 10
How to Shop Client delays in my ghantt chart so i can claim for delays 0
Would like to input 3 letters into a cell, each having a different numerical value 5

Top