SELECT MAX(flocknum), MIN(flocknum) ; FROM ; (SELECT SUBSTR(fm_flcode,5,4) flocknum ; FROM flckmast ; WHERE fm_hatched <= {4/1/07} ; AND fm_hatched >= {3/1/07} ; ) hello ; INTO CURSOR testRegards,
>>SET STRICTDATE TO 0 >> > >You're missing "AS" before flocknum. > > >SELECT MAX(flocknum) FROM ; >(SELECT SUBSTR(fm_flcode,5,4) AS flocknum ; >FROM flckmast ; >WHERE fm_hatched <= {4/1/07} ; >AND fm_hatched >= {3/1/07} ; >) ; >INTO CURSOR test >>