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!
 

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

Top