format

M

MN

I am sending fields from a table to a (text) .txt file.
Although the amount field is in 2 decimal places, the .txt file shows 12.00
as 12 only (for example) How can I format the field so that the dollar value
in the text file shows the 2 decimal places? Help will be appreciated.
(Access 97)
 
V

Van T. Dinh

Create a Query using the Calculated Field:

FormattedAmount: Format([YourField], "0.00")

(plus other Fields)

and use this Query as the source for your export rather than the Table.
 
J

John Vinson

The onyl way I know to force it something else is to convert the number
into a text field
Click to expand...
.... which is easily done using the Format() function, which accepts a
number and returns a string.

John W. Vinson[MVP]
 
S

Shark Jr.

I am having a simlar problem. I need to export the results of a query to a
..txt file but I cannot have the double quotes (Result not "Result") that
Access defaults to. Whats the code to just make it comma delimited?
 
Top