>>I have a table full of records with a date field in each record. The date field is D 8. For example I see 02/07/1999 when I browse the table. Of course there are other fields in the record, but the date field is the one I need to use to find the last record for a given year.
>
>
SELECT TOP 1 * FROM c1 WHERE YEAR(datefield) = 1995 ORDER BY datefield DESC
Kool!
Imagination is more important than knowledge