Renewal Date

Im stuck on another query.

I need a query that gives me members whos membership is going to run out in a month or under.


SELECT tblMember.memberNo, tblMember.dateJoined, tblMember.renewalDate

FROM tblMember

WHERE (((tblMember.renewalDate)<=Month(Date())-1))

ORDER BY tblMember.memberNo;

i think it should look something like that but theres something wrong somewhere.

tblMember.renewalDate CANNOT BE <=Month(Date())-1))
you have to compare months with months

by the way Dec 2000 and Dec 2001, ... all yield 12 for the month!!!

SELECT [tblMember].[memberNo], [tblMember].[dateJoined], [tblMember].[renewalDate]

FROM tblMember

WHERE (([tblMember].[renewalDate]) <DateAdd("m",1,Date()))

ORDER BY [tblMember].[memberNo];


That seems to work ok Thank you m_lazor for the responses to both posts

WHERE Month([tblMember].[renewalDate]) = Month(Date()-1) AND Year([tblMember].[renewalDate]) = Year(Date()-1)