Reset field every month september of a new year

[sykot]

Hey guys,

I am new here i have created a database for membership.

I have field for people who paid or not paid. Now what i want to do is that the field will set the field into "No" every begin september of a new school year.

I have tried to find more information but i could not find any positive answers.

Can some one help me please ???

[bruceR]

Probably the wrong approach. There should be a separate table of memberships with start date, expire date, memberID.

[sykot]

Well thats not a big deal to do that...

I have a start date and that is the date when they have been registered. I will put a expiredate table within the database. but i did not use a member id can i use for that the firstname and surname?