IIF statement help in a query

[Legends77]

Below is my current statement:
Gross TimeM: IIf([Product ID]="Scheduled",0,([NetRuntime]+[UnschedDelay])/60)

The problem is that due to someone's mess up I need to admend this for an exception for this month only.

I need to make a statement that has all the following

if [Product ID] = "Scheduled",0,if [Product ID} = "485231" and [Fiscal Year] = 2011 and [MonthID] = "Sept-10" then ([NetRuntime]+16+[UnschedDelay])/60,([NetRuntime]+[UnschedDelay])/60)

I know how to do the "and" in if statements in excel but they don't seem to work the same way in access (which doesn't surprise me).

Any and all help is greatly appreciated and thanks in advance!

 

[Golom]

Looks pretty much right. You just need to use IIF (not IF) and add some parentheses

IIf ([Product ID] = "Scheduled",
0,
IIf ([Product ID} = "485231" AND [Fiscal Year] = 2011 AND [MonthID] = "Sept-10", 
([NetRuntime]+16+[UnschedDelay])/60,
([NetRuntime]+[UnschedDelay])/60) )