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.

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.

--

Ken Snell
<MS ACCESS MVP>
http://www.accessmvp.com/KDSnell/



"Marc" <(E-Mail Removed)> wrote in message
news:642EA313-81FE-41C0-8D11-(E-Mail Removed)...
> 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.

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?

"Ken Snell [MVP]" wrote:

> 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.
>
> --
>
> Ken Snell
> <MS ACCESS MVP>
> http://www.accessmvp.com/KDSnell/
>
>
>
> "Marc" <(E-Mail Removed)> wrote in message
> news:642EA313-81FE-41C0-8D11-(E-Mail Removed)...
> > 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.
>
>
>

I have figured it out. Thanks!!

"Marc" wrote:

> 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?
>
> "Ken Snell [MVP]" wrote:
>
> > 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.
> >
> > --
> >
> > Ken Snell
> > <MS ACCESS MVP>
> > http://www.accessmvp.com/KDSnell/
> >
> >
> >
> > "Marc" <(E-Mail Removed)> wrote in message
> > news:642EA313-81FE-41C0-8D11-(E-Mail Removed)...
> > > 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.
> >
> >
> >