Hi, I'm exporting some data from a microsoft access database into an excel spreadsheet. I'm trying to sort the information I'm exporting first by the "CCy" field and then by the "Instr" field. The code I've tried is below and does not seem to provide what I'm looking for. Can you help pls ?
Sql = Sql & "ORDER BY (QuDailyPLFinal.CCy) And (QuDailyPLFinal.Instr) "