View Full Version : Quick Question- Show records from just the last 7 days?


Benjamin Bolduc
05-16-2002, 06:17 AM
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

Rich
05-16-2002, 07:06 AM
>=Date()-7

KKilfoil
05-16-2002, 07:07 AM
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")

Benjamin Bolduc
05-16-2002, 07:43 AM
Great, Thanks all http://www.access-programmers.co.uk/ubb/smile.gif