Number format in access query

[chegra26]

I am trying to format a field in an access query as a number without any decimals. The field in the table is set to General number with 0 decimal places. The number displays correctly in the query, however when I export to a text file (which is the format needed for an upload), the particular field has decimals places in it.

Anyone have a solution????

 

[chegra26]

Should show 4 numbers and no decimals
It finally worked after setting the field size to double with 0 decimal places and doing a format in the query to 4 places.

Thanks so much!