Leading zero in FMP 
Author Message
 Leading zero in FMP
In a FMP file I unfortunately planned on less than 10000 records and set
up to auto number them.. I now see that I need to extend the range and
face the task of adding leading zeroes to all of the existing records to
avoid ambiguity in look-ups between older four digit numbers and the newer
five digit ones.

Any suggestions besides manually going thropughthe file adding zeroes.



Fri, 09 Mar 2001 03:00:00 GMT
 Leading zero in FMP

Replace Right( "00000" & your field, 6)
Quote:

> In a FMP file I unfortunately planned on less than 10000 records and set
> up to auto number them.. I now see that I need to extend the range and
> face the task of adding leading zeroes to all of the existing records to
> avoid ambiguity in look-ups between older four digit numbers and the newer
> five digit ones.

> Any suggestions besides manually going thropughthe file adding zeroes.



Fri, 09 Mar 2001 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. FMP Leading Zero's in number fields ???

2. CDML COMMAND:[fmp-linkfirst] [fmp-linknext] [fmp-linklast] [fmp-linkprevious]

3. Leading Zeros/T-SQL idiot

4. Leading zeroes

5. Leading Zeros

6. leading zeros and right justified in numeric field

7. DTS to remove leading zeros

8. suppress leading zeros in select statement

9. drop leading zero when attach as a csv file

10. How remove leading zeros?

11. Insert icrement with leading letter and zero

12. Formatting Strings (Leading Zeros)


 
Powered by phpBB® Forum Software