Query Criteria Issue

[kopy]

I'm trying to use the following a the criteria for a query.

IIf(DatePart("d",Now())<=10,<=(Month(Now())-2),<=(Month(Now())-1))

Even though the first condition is met, the query returns no records. When I remove the <= signs, the query returns the records for February correctly.

Any insight or help will be greatly appreciated.

Thanks in advance,

Kopy

 

[Golom]

Try moving the operators

[COLOR=red]<=[/color]IIf(DatePart("d",Now())<=10,(Month(Now())-2),(Month(Now())-1))

[small]On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question. (Charles Babbage)[/small]

 

[Golom]

Or even more simply

<=Month(Now()) - IIf(Day(Now())<=10,2,1)

[small]On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question. (Charles Babbage)[/small]