Membership Expired

P

Paul

What I want to do is for a query to pick up records of
memberships that expired last month. So in real life it
would be December 03.

I have a membership record with all their personal
details and an expiry date on it. So in the criteria part
for the query on [DateExpired] what do I need to put in.
I know < date() would show those records before today,
but what I want is the records or memberships that
expired the previous month.

Thankx

Paul
 
S

Scott McDaniel

Change the criteria to "Between Now() And Now()-30" in the criteria box of
the [DateExpired] 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

Problem with Group By & Max Rcd 5
Renewing member database design question. 7
Membership Expired 1
Need Inactive/Expiring Records but not those who have renewed. 2
Exipry Date 1
Expiry Date Query 1
new to excell 2
Post Exp Date in Master Rcd (row) from trans record 8

Top