Prev: Splitting a table into smaller tables
Next: Calculate Diff Date?
From: Vadimbar on 27 Jan 2010 13:58
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
From: golfinray on 27 Jan 2010 14:16
Is the field a number or text? Sometimes, if it is text it will drop leading
zeros.
--
Milton Purdy
ACCESS
State of Arkansas


"Vadimbar" wrote:

> 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
From: Daryl S on 27 Jan 2010 15:05
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.
--
Daryl S


"Vadimbar" wrote:

> 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
 | 
Pages: 1
Prev: Splitting a table into smaller tables
Next: Calculate Diff Date?