Fixed Format Text Export

[Vicky]

I'm working on a data conversion project and I need to
send a fixed format txt export from an access table.
I've set up the fixed file format for field sizes and
macros to run all of the exports(as there are a lot of
tables to be exported).

My problem is I need the number fields to be right
justified and text fields left justified - the export
text function just always makes everything left justified.

Can anyone help me please.

 

[Douglas J. Steele]

You can kludge it by using computed fields in a query, and exporting the
query.

One approach is to concatenate spaces to the front of the number, then use
the Right function to take the end of the string. For example, if you want
the number to be right-aligned in 10 spaces, do something like:

Right$(" " & [MyNumber], 10)

 

[vicky]

Super thanks worked a treat!!

-----Original Message-----
You can kludge it by using computed fields in a query, and exporting the
query.

One approach is to concatenate spaces to the front of the number, then use
the Right function to take the end of the string. For example, if you want
the number to be right-aligned in 10 spaces, do something like:

Right$(" " & [MyNumber], 10)

--
Doug Steele, Microsoft Access MVP

I'm working on a data conversion project and I need to
send a fixed format txt export from an access table.
I've set up the fixed file format for field sizes and
macros to run all of the exports(as there are a lot of
tables to be exported).

My problem is I need the number fields to be right
justified and text fields left justified - the export
text function just always makes everything left justified.

Can anyone help me please.

.