Leading Zeros

[Guest]

I am trying to take numeric data from a query and export it to a text file, I
have tryed to use Right([lngParticipantSSN]+1000000000,9) as the criteria for
the query but it still drops the leading zeros, I have also tryed to use the
same query to update a new table with the field as a text field but when the
data comes out it still drops the leading zeros.

 

[Dirk Goldgar]

I am trying to take numeric data from a query and export it to a text
file, I have tryed to use Right([lngParticipantSSN]+1000000000,9) as
the criteria for the query but it still drops the leading zeros, I
have also tryed to use the same query to update a new table with the
field as a text field but when the data comes out it still drops the
leading zeros.

Try exporting the calculated field

Format(lngParticipantSSN, "000000000")