I am trying to export the result of a query named qryExport_results. I am using the following to do so:
DoCmd.TransferText acExportDelim, , "qryExport_results", strSaveFileName, True
The problem is that I get an error stating "Query must have at least one destination field". I am not sure what I am doing wrong. I tried to just disply the query to make sure it was working ok, and it appears it is. I am lost.