>>>Thank you William.
>>>
>>BTW, there are other ways to get the same information, but this one is the simplest to remember.
>
>I'd like to see it Naomi. Just out of curiosity.
The other simple way mentioned by Rich
select * from myTable where myDate = (select max(myDate) from myTable)
and another way more complex.
See also
Re: Getting most recent orders? Thread #
1249462 and the thread referenced there.
If it's not broken, fix it until it is.
My Blog