Thanks for the idea, but not quite what I had in mind. I want all of the newest records and ignore older matching records (matching on MailingListId and ListSelectId)
>SELECT TOP 10 MailingListId, ListSelectId, ;
> StateCountAsOF, ;
> StateCountId ;
> FROM StateCount ;
> INTO CURSOR zStateCount;
> ORDER BY StateCountAsOf DESC
>
>HTH
>
>>I'm trying to use the following SELECT to get me the most current record(s) from my table based on the DateTime field StateCountAsOf.
>>The field StateCountId is the Key field for each record.
>>
>>SELECT MailingListId, ListSelectId, ;
>> MAX(StateCountAsOF) AS StateCountAsOF, ;
>> StateCountId ;
>> FROM StateCount ;
>> GROUP BY MailingListId, ListSelectId ;
>> INTO CURSOR zStateCount
>>
>>When I run my SELECT I get the most current date but the field ListSelectId (which is a key into another table is for another record). I tried GROUP BY MAX(StateCountAsOf) and HAVING BY MAX(StateCountAsOf) but get syntax errors. I can't use StateCountId in my GROUP BY because I then get all records (since it is the key field).
Harold