export access query to text loses decimal places
I am exporting a query to a comma delimited text file, but I need to keep the decimal places. I have the field in the query defined as fixed 2 decimal places. I can't change the table because it is a linked table. When I export it does not keep the right most zeros. (40.00 = 40) The query displays correctly.