>The only problem I can see with this code, that you'll get DATE(9999,12,31) as a MinLCActDate if there're no records with DeedType = "LC". You can try to use Null instead of DATE(9999,12,31) to fix it (not tested).
Null would not work. I guess, if there are no DeedType='LC' in the whole file, these dates don't really matter... I'll check with my manager...
>
>>Exactly :) I figured this out by myself (decided to finally eat lunch). Anyway, three stars for you (I knew, you would be the first to answer :))
>>
>>>Something like
MIN(IIF(DeedType = "LC", date, DATE(9999,12,31)) AS MinLCActDate,
>< snip >
If it's not broken, fix it until it is.
My Blog