Membership Expired

[Paul]

I want a query which will display those dates that
expired last month and beyond.

The query shows the members ID, name and surname and
expiry date.

< Date() - only shows the expiry dates before present

What I do want is to display those dates that expired
last month and before that - in a real life example -
December and further ie '< todays month'

I tried < month(date()) - never worked

Thankx

Paul

 

[SteveS]

Paul,

If I understand, you want to find all [expiry date] in the previous
month and earlier. Which really means any date less than (earlier than)
the first of the current month.

In the criteria row of the [expiry date] column enter:

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

In a real life example, the query will find all expiry dates less than
1/1/2004, ie 12/31/2003 and earlier.

HTH

Steve