Access exports ID instead of percentage

[jj1]

AQuery drives data from table1 with 3 fields field 1 is autonumber, field 2 is field name and third field has percentages so a data type is %


When I am using the code below it's transferring the % as ID. so I get field 2 instead of field 3

 Dim Book3 As String
    Book3 = "C:\Users\Desktop\1\book3.xlsx"
    DoCmd.TransferSpreadsheet acExport, , "AQuery", Book3

How can I solve this

[ranman256]

Then your query is wrong...it will export each field as is.

[jj1]

SELECT ATable.Results1, ATable.Results2, ATable.Results3, ATable.Results4, ATable.Results5, ATable.Results6, ATable.AName
FROM ATable;
Here is my query
Result field properties:
datatype = percentage
Field size single
Format percentage
decimal places 2