hi, i am currently writing a database for a local football club
Now, each member has an "annual fee" field, and this has to be paid yearly
Each member also has a "membership began" field, stating the date on which they became members of the club
Now, what i've done is create a query which includes the members name and address fields, the "annual fee" field and the "membership began" field.
In the "criteria" section of the field "membership began", i put the following function
Between DateAdd("ww",1,Date()) And Date()
This picks up any members who's "membership began" on the date 1 week either side of todays date which is what i want, so a letter can be sent to them saying their annual fee is due.
BUT, the problem with this is, it has to be the same year as the year membership began on, whereas i want the query to pick up the members who's contracts need renewing EVERY year.
thats quite complicated so here's an example
Member name: John Smith
Membership began: 08/10/2001
Now, todays date is 6/10/2002
the query does not pick up John as the year is different - i'm wondering if there is a way to get it to select members on the first 2 parts of the date i.e. "08/10" irrelevant of the year.
Any help is much appreciated
thanks in advance
Tim
Now, each member has an "annual fee" field, and this has to be paid yearly
Each member also has a "membership began" field, stating the date on which they became members of the club
Now, what i've done is create a query which includes the members name and address fields, the "annual fee" field and the "membership began" field.
In the "criteria" section of the field "membership began", i put the following function
Between DateAdd("ww",1,Date()) And Date()
This picks up any members who's "membership began" on the date 1 week either side of todays date which is what i want, so a letter can be sent to them saying their annual fee is due.
BUT, the problem with this is, it has to be the same year as the year membership began on, whereas i want the query to pick up the members who's contracts need renewing EVERY year.
thats quite complicated so here's an example
Member name: John Smith
Membership began: 08/10/2001
Now, todays date is 6/10/2002
the query does not pick up John as the year is different - i'm wondering if there is a way to get it to select members on the first 2 parts of the date i.e. "08/10" irrelevant of the year.
Any help is much appreciated
thanks in advance
Tim
