Exporting numeric fields with leading zeroes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am unable to export a query to a fixed format text file with leading
zeroes. The query will display the zeroes, but the export process strips
them off, and outputs the field as fixed length, zero suppressed, left
justified, blank filled on the right.

I need the zero filled field in order to format the output for compatibility
with a legacy application.

Thanx in advance.
 
Hi,

The usual way round this is to use the format function in a calculated
field in a query, and then export the query, e.g.

fMyField: Format([MyField], "00000000")

for an 8-character wide field with leading zeroes.
 
Worked Great.
Thanks!

John Nurick said:
Hi,

The usual way round this is to use the format function in a calculated
field in a query, and then export the query, e.g.

fMyField: Format([MyField], "00000000")

for an 8-character wide field with leading zeroes.

I am unable to export a query to a fixed format text file with leading
zeroes. The query will display the zeroes, but the export process strips
them off, and outputs the field as fixed length, zero suppressed, left
justified, blank filled on the right.

I need the zero filled field in order to format the output for compatibility
with a legacy application.

Thanx in advance.
Click to expand...
Click to expand...
 
Back
Top