Membership Expired

[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

 

[Scott McDaniel]

Change the criteria to "Between Now() And Now()-30" in the criteria box of
the [DateExpired] field

 

[Jack Peacock]

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.

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