I know I have asked this before but the SPT statement was not as complicated. I need the gentime to be the minimum when two or more records are on the same date.

String sql = "SELECT gentime, link1, gatetype FROM history" +;
" Join cardholder On history.link3 = cardholder.recordid" +;
" Join gatenames On history.link1 = gatenames.gatenumb" +;
" WHERE cardholder.note1 = '56230'" +;
" And gentime >= '" + gateactivityarray[i][0] +;
"' And gentime < '" + tempDate + "' Order By gentime"