cFld1= "DateFld" cFld2= "TimeFld" cSQL= "SELECT * FROM MyTable ORDER BY &cFld1, &cFld2" &cSQLAlthough I know most people wouldnt not write it this way, some might,
cSQL= "SELECT * FROM MyTable ORDER BY " + m.cFld1 + "," + m.cFld2but I still prefer the second way.