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)