Creating A Report That Conforms To ASCII Format Of Another Data Collection System

I have a need to convert the export of an Access report to an ASCII file.

The export needs to have a specific format - described below:

Field Position | Field Length | Field Name | Field format

1-6 | 6 | Member # | text - right justified
7-12 | 6 | Trans Date | YYMMDD
13-15 | 3 | Pay code | Alpha/ NUM - Left
16-26 | 11 | Amount | -9999999.99 (*)
64-71 | 8 | Check # | Right

general comments and questions:

This report needs to interface with some sort of transaction accounting system - No Idea what it is, but this format of the report will interface.

The field positions go from 1 to 73. I need only supply the data above, so the check # is way out of sequence. Do I need to have the space inbetween "Amount" and Check Number in the report? Will a simple text file work with all the fieds together? or will I need the space in there? Is there a way to design a report in an ASCII format in access?

Specific Questions

I think I need to change the format of the amount and date fields. I am currently using the short date format 8/30/04, but need to return the date as YYMMDD - 040830. How can I change this format to reflect the ASCII format. The form is also set with the default "=Date()" so the user doesn't have to enter the date everytime - it can also be edited for older data. I would like the date to appear the way it is on the form 08/30/04 but get entered to the table as 040830. Is there a way to do that?

The amount field is odd - I'll include the exact criteria that is desired:

"All Amount Fields must be right justified and space filled. If the amount is a credit, show the "-" sign at the beginning of the number. Payment should be entered as positive amounts. If zero, assign the fied as 0.00 (space filled)"

Is this just a mask that needs to be added? Currently, The field shows $7.00 when 7 is entered to add cent, you must type in 7.50, tab will put in the "$". I need to get rid of the $ and space fill the field?

Any help would be great