Hello, I have a make table query that I then created a specification to export it to a text file. Some of the fields contain decimal places, but the business I am creating the text file for would like to elimanate all decimals and right align the numeric values. Thank you in advance!
Example:
My table data consists of:
Field1 Field2
14.25 .25
My text file specifications show
Field1 (Position1-5) (Length 5) (Type S9v999)
Field 2 (Position 6 -11) (Length 6) (Type S99v9999)
This is what I would like my text file to look like after output, but I can't figure out how to right align the fields or remove decimals?
1425 25
Example:
My table data consists of:
Field1 Field2
14.25 .25
My text file specifications show
Field1 (Position1-5) (Length 5) (Type S9v999)
Field 2 (Position 6 -11) (Length 6) (Type S99v9999)
This is what I would like my text file to look like after output, but I can't figure out how to right align the fields or remove decimals?
1425 25