Hi Everyone,

I was just wondering if there was a way to query the data on a form to only show records from the past 7 days.

Thanks!
-Ben

>=Date()-7

In a query, put ">Date()-7" (without quotes) under the arropriate date field as the criteria (or perhaps ">= Date()-7", depending on how you define "the past 7 days")

Great, Thanks all http://www.access-programmers.co.uk/ubb/smile.gif