export wizard

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

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?
 
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.
 
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.

John Nurick said:
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?
Click to expand...
Click to expand...
 
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.

John Nurick said:
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?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top