Expiration Date

[kgnoel]

First timer and new to MS Access!!

I created a database for my wife to keep track of a non-profit teacher
organzation's memebership.
I am trying to create an "Expired Membership" report. I would like the report
to only list the members with expired membership. ( Renewal date + 330 days)
My date field is in 01-01-08 format.

I am using Vista and MS Acccess 2007

Thank you,
Kevin

 

[John Spencer]

Where DateAdd("d",330,[Renewal Date]) < Date()

In a query, add a calculated field

Field: Expires: DateAdd("d",330,[Renewal Date])
Criteria: < Date()



John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

 

[kgnoel via AccessMonster.com]

Thanks - I'll give it a try

Where DateAdd("d",330,[Renewal Date]) < Date()

In a query, add a calculated field

Field: Expires: DateAdd("d",330,[Renewal Date])
Criteria: < Date()

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

First timer and new to MS Access!!

[quoted text clipped - 8 lines]

Thank you,
Kevin