sort export information

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) "

tks
f19lAsked:
Who is Participating?
 
Jorge PaulinoIT Pro/DeveloperCommented:
try

Sql = Sql & "ORDER BY (QuDailyPLFinal.CCy),(QuDailyPLFinal.Instr) "
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.