>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 min(gentime) as 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 + "' group by link1, gatetype, DateField Order By gentime"
Steven,
See changes inline.
If this is not what you want, please give more info about tables structures and may be some sample data. I'm suspecting you may need derived tables with inner join but this would not work with SPT.
If it's not broken, fix it until it is.
My Blog