>>>>>You should get the wroong date returned.
>>
>>I played with that, and you're wrong (at least in my dimension!)
>
>Larry is not saying that you will get the wrong temperature for each city; he is saying that your query will tell you the wrong DATE for that temperature. Just looking at your query, I would think the date would be incorrect, unless the MAX temperature was on the last record for each city.
>
>Are the dates correct in your results?
Thank you. You seem to have explained my position better than I did. < s >
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao