Hi, I want to export to a text tab delimited file. That is all possible, but I have 4 colums with number in it. The last column I would need to format without decimals. Can I format the numbers somehow in the code. I tried it in the query and in the export specification, but did not work....any ideas?
SELECT TBL_SHIPMENTS.Customernumber, TBL_SHIPMENTS.Salesoffice, TBL_SHIPMENTS.Product, TBL_SHIPMENTS.Curr_code, TBL_SHIPMENTS.Month, TBL_SHIPMENTS.Ship_list_clc_legal, TBL_SHIPMENTS.Ship_list_lc_legal, TBL_SHIPMENTS.Ship_net_clc_legal, TBL_SHIPMENTS.Ship_net_lc_legal, Round([tbl_shipments]![Units],0) AS Units