Export via Query

J

jubejoie

Hello again,

Field2 = numeric len=9 defined as long integer format=
000000000

i.e. data entry to this field 12, appears on table as
000000012

GOOD SO FAR

when I export this field I get 12 in the field, right
justified with NO leading zeros!

Although, Field1 = numeric len=5 defined as integer
format= 00000

i.e data entry to this field 1, appears on table as 00001
PERFECT

When I export this field IT COMES OUT 00001 ...PERFECT

Why does field1 exports correctly and field2 does not?
They are the same in field descriptions.

HELP!
 
Top