am exporting a query table to a CSV file and its all working ok but my only problem is that the Salary Field is showing two decimals after the export that i dont want,what i tried so far is 1- reformat the field in the query to loose the decimals like this
Amount: Format(Salary,"0")
when i run the query (inside Access) there are no decimals but after the export they are still there 2- remove the decimals from (Region and Language) in the control panel(i dont like this approach) and the result is that the Zeros are gone but the decimal point still there.
It was a faulty Office app,re installing it fixed the problem.