How to Delete Record after current date?

[Herdrich]

I have a database that allows individuals access to our complex until a specific date. How can i have Access delete the record of that person after they have expired?

Ex
Name: Date Entered: Date Expires:
Joe 08/05/09 10/17/09
John 08/05/09 10/16/09
Dan 08/05/09 10/30/09

Joe would reamin on the list until midnight John would be removed and Dan will continue to remain on the list.

 

[SkipVought]

Hi,

Using your posted data, why would Joe, "reamin on the list until midnight," while John, "would be removed?"

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[Herdrich]

Sorry if the current date was 10/17/09 i forgot what day it was when i was typing.

 

[SkipVought]

Hi,

Delete *
From [Yourtable]
Where [Date Expires]<Date()

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}