i want to a query.
SELECT MAX(fNum) FROM tTable WHERE fDate IN (SELECT MAX(fDate) FROM
tTable WHERE fDate IN (SELECT fDate
FROM tTable WHERE fDate IN (SELECT fDate FROM tTable WHERE
(fRegion="Calif o") AND (fProduct="G274 ") AND (fColor="Brown" ) AND
(fDate<=#5/13/2006#))))
unfortunately, the upper query is not working in my hope.
i want to following query.
there are records in (fRegion="Calif o") AND (fProduct="G274 ") AND
(fColor="Brown" ) AND (fDate<=#5/13/2006#).
there are records in maximum fDate in the records.
and then last
there is record of a maximum fNum in the records.
*** Sent via Developersdex http://www.developersdex.com ***