Expiry Date

[Paul]

I have a club members table which lists thier personal
details as well as a date field which shows when thier
membership expires.

What I want to do/know is to create a query which shows
those members who are in thier last month of thier
membership. What is the criteria I need to enter for this
to work

Thankx

Paul

 

[Lee T.]

-----Original Message-----



I have a club members table which lists thier personal
details as well as a date field which shows when thier
membership expires.

What I want to do/know is to create a query which shows
those members who are in thier last month of thier
membership. What is the criteria I need to enter for this
to work

Thankx

Paul


.

Paul,

I think this should work for you. I made a quick table
called membership with an ID and date (and type). It
worked in my test and I hope it works for you.

SELECT membership.memid, membership.memtype,
membership.memexpire
FROM membership
WHERE [membership.memexpire] < now() or
( Month([membership.memexpire])=(Month(Now()) ) AND
Year([membership.memexpire])=(Year(Now()) ));


Lee T.

 

[PC Datasheet]

Paul,

Create a totals query that includes the member and his expiration date. In the
expiration date field, change Group by to max. If you run the query at this
point, you will get the expiration dates of all the members. However, since you
want only the members with expiration dates this month, put the following
expression in the criteria of the expiration date field:
Month(Date())

The query will now only return the members whose expiration date is this month.