Exporting as Text only 2 decimal places

[poet_will]

I'm having a problem exporting my table as text and having three fields reporting only 2 decimal places instead of the 4 that i need.

I'm using Access 200 on Windows XP Pro.

I searched the forums and the only thing i could find was to create a querry and using ColumnName: str([dblNumber]) somehow. I don't really unerstand what they were trying to do except that somehow this converts the number to a string. This would work I guess, but I couldn't get it to work.

I have also read somehting about changing the fields in the MSysIMEXColumns table somehow to allow more decimal places in the exprted text file.

Thanks for helping.

Will

 

[FoFa]

Look up the format function in help, it's output is a string and you ocan specify decimal places