Membership Expired

  • Thread starter Thread starter Paul
  • Start date Start date
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
 
Change the criteria to "Between Now() And Now()-30" in the criteria box of
the [DateExpired] field
 
Paul said:
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.
Click to expand...
Sounds like what you need is to first determine the cutoff date based on the
first of current month, whatever it may be when you run the app.

< DateSerial( Year(Date()), Month(Date()), 1)

This gives you all records earlier than the first day of the current month.
Jack Peacock
 
Back
Top