Leading Zeros


G

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.
 
Ad

Advertisements

D

Dirk Goldgar

David Widener said:
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")
 

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