>LPARAMETER tdTarget
>
>m.tdTarget = IIF(VARTYPE(m.tdTarget) = "D" AND NOT EMPTY(m.tdTarget), tdTarget, CTOD("04/01/2001")
>
>SELECT * ;
> FROM Stest St1 ;
> WHERE code + TRANSFORM(Date) IN ;
> (SELECT code + TRANSFORM(MIN(Date)) ;
> FROM Stest S2 ;
> GROUP BY Code ;
> HAVING MONTH(MIN(SDate)) = m.tdTarget)
>
>Regards,
>Thom C.

<What's SDate in the above SQL statement? It's not defined in the statement itself.>>

Damn, damn, damn.

It should look like :

SELECT * ;
FROM Stest St1 ;
WHERE code + TRANSFORM(Date) IN ;
(SELECT code + TRANSFORM(MIN(Date)) ;
FROM Stest S2 ;
GROUP BY Code ;
HAVING MONTH(MIN(Date)) = MONTH(m.tdTarget))

Snatching defeat from the jaws of victory.

Thom C.