From: "Ed Dressel" <Dressel@...>

>I have a table with a date field. I need to get a value from the
> record with the maximum date--but the date can not be greater then today.
>
> How would I do that?

Select First 1 FieldYouNeed from SomeTable
Where DateField <= "Today"
Order by DateField desc, OtherOrderByFields

HTH
Woody (TMW)