access vba sql
I need to sort a query with nulls at the end
this is my order by statement:
sQuery = sQuery & "or MfrNumCondensed = '" & rng & "' order by IFF(XRefType IS NULL,1,0), CompName asc, GPrice ASC;" & vbCrLf
Trying to sort by Xreftype first put nulls at the end.
then continue to sort by the other columns...
ANY NULLS AT THE BOTTOM