SQL variable to Sort

[MadTom]

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

[June7]

You need a separator space in front of DESC.

Why bother with concatenation?

strSort = "P_Name, P_Quantity DESC"

[MadTom]

That works but doesn't sort on Quantity first! Sorts on Name then Quantity. So if I use "tblParts.P_Quantity DESC, tblParts.P_Name" this will work the way I need it. Quantity then Name. I knew it was something easy! This is my goto after many searches on google.
Thanks!
Tom