Exporting Fixed Width Text

[Marc]

I'm curently trying to export a table to a fixed width text file. I have 2
columns that that are prices. When I try to export it truncates the number.
For example if the price is 78 dollars then it needs to be 78.00 format. Any
ideas on how I can keep it from truncating the zeros?

Also I need the price columns to be aligned right any thoughts on how to do
that as well.

 

[Ken Snell [MVP]]

Create a query that is based on your table. Put all the fields from the
table on the query grid.

For each of the price fields, change the name in the Field: cell to an
expression similar to this:

PriceName1: Format(PriceField1, "0.00")

I've used generic names above; use correct names and a meaningful alias
(PriceName1) name. Different alias names needed for each field.

Then export the query instead of the table. Be sure to change your Export
specification (if you're using one) to look for the alias names instead of
the original field names.

 

[Marc]

That worked great! Thank you!

If I wanted the format of the price to be 00000938.25 is that possible to
have the price in that format when your exporting to a text?

 

[Marc]

I have figured it out. Thanks!!

That worked great! Thank you!

If I wanted the format of the price to be 00000938.25 is that possible to
have the price in that format when your exporting to a text?