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
 
Top