Problem with number format when exporting to fixed width

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

Guest

I need so help identifying why a number format is not exporting correctly to
a fixed width format.
In the table, the format for the number is $446.28. In the query, I have
changed the format of the number so the result is 446 (no decimal places and
no $ sign).
When I try to export the query to a fixed width format, the resulting format
for this is $446.00. What gives? What am I doing wrong?
 
Hi Burnsy,

It the that number field a Double or Long Integer. I guess it is a double
that is why it is coming out with decimals. Try to make it a Long Integer
and see if that will fix your problem.

Hope this helps.
 
I need so help identifying why a number format is not exporting correctly to
a fixed width format.
In the table, the format for the number is $446.28. In the query, I have
changed the format of the number so the result is 446 (no decimal places and
no $ sign).
When I try to export the query to a fixed width format, the resulting format
for this is $446.00. What gives? What am I doing wrong?
Click to expand...

An Export *IGNORES* any format settings on the field.

What you need to do is to use the Format() *function* in a calculated
field to convert the number to a string, and export that.

John W. Vinson[MVP]
 
Back
Top