Subject Re: Record with maximum date, but date can not be greater then today
Author Ed Dressel
--- In, "Ed Dressel" <Dressel@...> wrote:
> 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

I've got this:

select NeededValue from MyTable
where DateValue =
(select Max(DateValue) from MyTable where DateValue <=

I would prefer to get the Rate_ID field value, rather the the
Rate_Date field value (Rate_Date is a float). Is that possible?

Ed Dressel