I have a table like this:<BR>TaskID (long) ; WeekDate (Date) ; RemainingHours (Double)<BR><BR>This table will be appended on a weekly basis with records containing the remaining hours for all the tasks that have a modified remaining hour for that week.<BR><BR>Now, I want to run a query that returns me for each TaskID only one record, namely the one that is closest to a given date, provided to the query as a parameter.<BR><BR>Something like "SELECT MAX(WEEKDATE) FROM MYTABLE WHERE (WEEKDATE &#060; paramDate)". I cannot find something that works for me in Microsoft Access.<BR><BR>Thanks in advance,<BR>Filip