999.99 or -99.99 The width includes any sign and decimal point.
Beware that if you try to put in 9999.99 you'l get 10000 and 99999.99 you'l get 100000. -999.99 will get you -1000 and -9999.99 will get you -10000. 6 total significant characters. Fred On Tue, Aug 7, 2012 at 1:21 PM, John Weller <[email protected]> wrote: > I'm having a senior moment! What is the maximum value a numeric field of > size 6,2 in a dbf can hold? Is it 9999.99 or 999.99 - in other words, do I > have to make an allowance for the decimal point? Also, if it is 9999.99 > can > it also hold -9999.99? This is so fundamental that I can't find it in the > Help file. > > Thanks > > John Weller > 01380 723235 > 07976 393631 > > > > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/cajcbkspwb3i9nq6mmlhnqsfa8gfjsrozbg-9bgmmw6vo2ok...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
