Alternative to the IIF 1

[kopy]

Hi, I'm trying to create criteria for a query. I started using an Imediate If statement. But now I realize that since the field I'm trying to set the criteria for([tblAdmissionsTallySheet].[MonthNumber]) is numeric and the result of an Immediate If needs to be a string that I need to find an laternative approach.

An ideas will be greatly appreciated. The IIf I wrote is below.

IIf(Month(Date())<=6,([tblAdmissionsTallySheet].[MonthNumber]) Between 1 And Month(Date())+6,([tblAdmissionsTallySheet].[MonthNumber]) Between 1 And Month(Date())-6)

Thanks in advance for your help,

Kopy

 

[PHV]

And this (in criteria cell of MonthNumber) ?
Between 1 And Month(Date()) + IIf(Month(Date())<=6, 6, -6)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886