Help with using the AND condition

[ssturges]

So, I'm trying to use a condition statement to show a record only when. A records month is 1 month away from the ending month, or the "end date".

Basically Im trying to say, if the current date has a difference of at no more than 1 month from the end date, then show.



Thus far I have this is in my criteria field:

DateAdd("m",[LeasingTerm],[CommenceDate])<DateAdd("m",-1,[CommenceDate]) AND( [CommenceDate] > DateAdd("m",([Leasing Term] -1),[CommenceDate])

Any help would be greatly appreciated thanks

[June7]

Need to understand data structure better. You say '1 month from the end date' but use CommenceDate in the criteria. What field is criteria for? Is this expression in a query? Show the entire SQL statement.