Query to find the n highest records

[MSAccess_newbie]

Hello,

I have a table which stores information weekly. I have a field called weekly which increments 1, 2,3 ...etc. Id like to query the table for the most recent (highest) 4 weeks. Can anyone help with the sql?

 

[MSAccess_newbie]

For anyone who runs into the same problem, I tried this which works (probably not the best way)

SELECT [2GFullWk_Tab].Week
FROM 2GFullWk_Tab
GROUP BY [2GFullWk_Tab].Week
HAVING ((([2GFullWk_Tab].Week)>Format(Date(),"ww")-"5" And ([2GFullWk_Tab].Week)<Format(Date(),"ww")));

I also found this article useful.....
http://office.microsoft.com/en-us/access/HP051880331033.aspx#1​