Expiry Date Query

  • Thread starter Thread starter Paul
  • Start date Start date
P

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
 
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
Click to expand...

BETWEEN Date() AND DateAdd("m", 1, Date())

on the ExpiryDate field.
 
Back
Top