I have two fields I need to send out to a text file to be picked up by the Mainframe. The first needs to be a five byte field containing the orders quantity (integer). The Access 2.0 table currently stores this field as an integer and it is usualy the value 1. It needs to look like this 00001 in the text field.
The second field is a currency field that needs to look like 000001125. Nine bytes in the text file with no decimal representing the $11.25 value in the table.
What function(s) do I use to these fields ready to export to the text field. It doesn't appear that the export spec does this for me, so, I feel that I must export text fields already formatted.
Thanks for the assistance.