Rounding in Access and Exporting a File

[Alexandra]

Hi,

Originally I had to use the following formula in a query:

Amount_Final: Round([Amount],2)

Now I get the following dispaly

Amount_Fianl
0
1.7
43

Can you provide me a formula that will display my numbers like:

Amount
0.00
1.70
43.00

Thanks

 

[Marshall Barton]

Originally I had to use the following formula in a query:

Amount_Final: Round([Amount],2)

Now I get the following dispaly

Amount_Fianl
0
1.7
43

Can you provide me a formula that will display my numbers like:

Amount
0.00
1.70
43.00

No formula needed, just set the Format property of whatever
you are using to display the values to 0.00

 

[Alexandra]

I appended the query results in a table that had the following format for the
Amount_Final field:

Field Size: Double, Format: Fixed, Decimal Places: 2

This looks fine in access but when I export the file in a text file format
it still shows:

Final Amount
0
1.7
43

I need access to export the the table in a text file with the following
amounts:

0.00
1.70
43.00

How can this be fixed?

Originally I had to use the following formula in a query:

Amount_Final: Round([Amount],2)

Now I get the following dispaly

Amount_Fianl
0
1.7
43

Can you provide me a formula that will display my numbers like:

Amount
0.00
1.70
43.00

No formula needed, just set the Format property of whatever
you are using to display the values to 0.00

 

[Marshall Barton]

Ohhh, there's an export process involved. Well then, if
wherever you are exporting to can not display the format you
want, you'll have to convert the value to Text by using the
Format function. Use a calculated field in the query you
are exporting:
fixedamount: Format(Amount_Final, "0.00")

That sounds like you would do to make a text/csv file look
nicer, but is it really necessary to the program that will
eventually import the text/csv file?
--
Marsh
MVP [MS Access]

I appended the query results in a table that had the following format for the
Amount_Final field:

Field Size: Double, Format: Fixed, Decimal Places: 2

This looks fine in access but when I export the file in a text file format
it still shows:

Final Amount
0
1.7
43

I need access to export the the table in a text file with the following
amounts:

0.00
1.70
43.00

Originally I had to use the following formula in a query:

Amount_Final: Round([Amount],2)

Now I get the following dispaly

Amount_Fianl
0
1.7
43

Can you provide me a formula that will display my numbers like:

Amount
0.00
1.70
43.00

No formula needed, just set the Format property of whatever
you are using to display the values to 0.00

 

[Alexandra]

I just wanted to let you know that your help is really appreciated. The
formula you provided me worked!!! Thanks so much!!!! Yes, my vendor is using
my text file to print some dollar amounts... I needed it with the format 0.00

Ohhh, there's an export process involved. Well then, if
wherever you are exporting to can not display the format you
want, you'll have to convert the value to Text by using the
Format function. Use a calculated field in the query you
are exporting:
fixedamount: Format(Amount_Final, "0.00")

That sounds like you would do to make a text/csv file look
nicer, but is it really necessary to the program that will
eventually import the text/csv file?
--
Marsh
MVP [MS Access]

I appended the query results in a table that had the following format for the
Amount_Final field:

Field Size: Double, Format: Fixed, Decimal Places: 2

This looks fine in access but when I export the file in a text file format
it still shows:

Final Amount
0
1.7
43

I need access to export the the table in a text file with the following
amounts:

0.00
1.70
43.00

Alexandra wrote:
Originally I had to use the following formula in a query:

Amount_Final: Round([Amount],2)

Now I get the following dispaly

Amount_Fianl
0
1.7
43

Can you provide me a formula that will display my numbers like:

Amount
0.00
1.70
43.00


No formula needed, just set the Format property of whatever
you are using to display the values to 0.00

.