Hi All
basically im trying to setup a click button that will export my query as a text file ( the text file will then be fixed width and i have already setup the specifications for this)
i think i get how to complete the export part as below
OutFilePath = "file location i want the data to be exported to"
DoCmd.TransferText acExportFixed, "Welcome output query Export Specification", WelcomeOutput, OutFilePath, True
i just dont know how to run the query and link it to the export
Hope this makes sense and thanks in advance for any support provided.