Expiry Date Query

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
 
J

John Vinson

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Exipry Date 1
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Expiry Date 2
Membership Expired 1
Expiry dates sql problems 0
Expiry dates query 1
Query Results in Data Entry Form Not Sticking 2
Renewing member database design question. 7

Top