I have this SQL variable statement and it works to sort in descending order. strSort = "tblParts.[P_Quantity]" & "Desc" ( "ORDER BY " & strSort & ";").
I would like to add a 2nd Sort criteria to my strSort statement,"tblParts.[P_Name], but can't seem to get the correct format.
"tblParts.[P_Quantity], tblParts.[P_Name]" works but I would like the descending order.
Thanks,
Tom