query export wont allow a zero value?

V

Vadimbar

I runa query and forcing a specific value with a leading zero.
i.e. 011210

When I run the export the first zero is eliminated. 11210

Any ideas why this happens? When ever I change the zero to a 1 or 2 works
perfectly.

The query always shows the correct value but the export text file is always
off. Any ideas why?

Thank you
 
G

golfinray

Is the field a number or text? Sometimes, if it is text it will drop leading
zeros.
 
D

Daryl S

If you are exporting to Excel, and this should be a text field, prepend a
single-quote to what you are exporting. Then Excel will keep the text
formatting.
 

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

Similar Threads

Query to text file cuts my leading zeros off. 4
Counting trailer numbers 2
Appending zero-length string 3
Sum Expression gives 1.45519152283669E-11 instead of 0 (zero) 6
Export Query to Text without delimiters 4
Division by zero error 16
Query to calculate despite form fields being left blank 2
Export number without decimals 1

Top