Query expression calling for a previous month

[rbrule]

Hello again,
I am now creating a calculated field in a query which draws data from a month previous to the current month. For example, IIf ([mfg]=a and [date of sale]= any date last month, 250,0)

How would I express " any date last month" so that the results would allways be automatic.

rbrule

 

[Dugantrain]

Replace the "any day last month" with

(Month(Date()))-1

and [date of sale] with

Month([date of sale])

 

[rbrule]

Hello,

Your expression brings me to last month (January), but doesn't distinguish between last month this year, or January in any previous years.

Is there a way to refine it? Basically I need the expression to refer to the month immediately previous to now.

Thanks
rbrule

 

[Mile-O]

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=61385

 

[rbrule]

I am sorry to be such a knot head, but I tried both of the last two scenarios and I get an error message that says

"The expression you entered has a function containing the wrong number of arguments."

What might I be doing wrong?

 

[rbrule]

Thank you very much for your help. I finally got it to work. I must have been typing something wrong.