I'm using MS Access (yeah, silly, I know) to store news from a site, I have a Date/Time field which I would like to use to get records from the last week or month but I can seem to put together a query that can pull this off

Anyone got any suggestions ?