D
data reporting
When I export an access report to a text file, I get a blank space between
each field. This is resulting in the data in my text file being offset. For
example, I have a numeric field which needs to fill 8 columns and an alpha
field which needs to fill 8 columns of a text file. The alpha column needs
to start at column 9 (it just does not look that way in the example).
12345 abc
12345678xyz
When I export the report as a text file, I get an extra blank space, which
offsets my alpha field, as in the example below.
12345 abc
12345678 xyz
I am using a report (as opposed to exporting the query) because I need the
layout of the report - my example is far more simplified than the actual data
I am working with.
each field. This is resulting in the data in my text file being offset. For
example, I have a numeric field which needs to fill 8 columns and an alpha
field which needs to fill 8 columns of a text file. The alpha column needs
to start at column 9 (it just does not look that way in the example).
12345 abc
12345678xyz
When I export the report as a text file, I get an extra blank space, which
offsets my alpha field, as in the example below.
12345 abc
12345678 xyz
I am using a report (as opposed to exporting the query) because I need the
layout of the report - my example is far more simplified than the actual data
I am working with.