Renewal Query

[burnoutuk]

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.

 

[dcx693]

Do you mean a month from the current date?
WHERE ((tblMember.renewalDate) < DateAdd("m",1,Date()))

Or within the current calendar month?
WHERE ((tblMember.renewalDate) < DateSerial(Year(Date),Month(Date)+1,1))

 

[AlienRay]

The problem is your WHERE statement. Month(Date())-1) is always going to return the number of the previous month, i.e., a number between 0 and 11. You would be better off using the DateDiff function.

 

[burnoutuk]

WHERE ((tblMember.renewalDate) < DateAdd("m",1,Date()))
That works, thank you fast response

Cheers