Exipry 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

 

[Douglas J. Steele]

What's your definition of "last month". With this being January, do you want
the members whose expiry dates are in January, or those whose dates are in
February?

To get those who expire in this month, try:

WHERE ExpiryDt BETWEEN DateSerial(Year(Date()), Month(Date()), 1) AND
DateSerial(Year(Date()), Month(Date()) + 1, 0)

For next month, try

WHERE ExpiryDt BETWEEN DateSerial(Year(Date()), Month(Date()) + 1, 1) AND
DateSerial(Year(Date()), Month(Date()) + 2, 0)