export wizard

[Guest]

Can anyone tell me why the export wizard left-justifies numeric fields and
then adds 2 decimal points to them? Is there any way to fix this?

 

[John Nurick]

Create a query that uses calculated fields that format the values the
way you want them. For instance,
fXXX: Right(Space(12) & Format([XXX], "0"), 12)
will right-align the value in field XXX in a 12-character-wide column,
with no decimal places.

 

[Guest]

This didn't fix the problem. The file format is fine, until the last 'finish'
during the export. It seems to be a problem with the export wizard itself,
and not how the fields are formatted in the query.
I am using Access 2002, but I even tried it at home, using Access 1997. Got
the same problem.

Create a query that uses calculated fields that format the values the
way you want them. For instance,
fXXX: Right(Space(12) & Format([XXX], "0"), 12)
will right-align the value in field XXX in a 12-character-wide column,
with no decimal places.

Can anyone tell me why the export wizard left-justifies numeric fields and
then adds 2 decimal points to them? Is there any way to fix this?

 

[John Nurick]

Are you using calculated fields like my example below, or are you using
the Format property of fields in the query?

This didn't fix the problem. The file format is fine, until the last 'finish'
during the export. It seems to be a problem with the export wizard itself,
and not how the fields are formatted in the query.
I am using Access 2002, but I even tried it at home, using Access 1997. Got
the same problem.

Create a query that uses calculated fields that format the values the
way you want them. For instance,
fXXX: Right(Space(12) & Format([XXX], "0"), 12)
will right-align the value in field XXX in a 12-character-wide column,
with no decimal places.

Can anyone tell me why the export wizard left-justifies numeric fields and
then adds 2 decimal points to them? Is there any way to fix this?