Quick Question- Show records from just the last 7 days? (1 Viewer)

[Benjamin Bolduc]

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]

>=Date()-7

 

[KKilfoil]

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]

Great, Thanks all