Not good with IIF statements

[spcscooter via AccessMonster.com]

I am in the need of an IIF statement. I am looking to do the following:

If the field [Current CommTech Level] equals CommTech 1 then add 90 days to
the field [Date of Last Promotion]. If not then the field is blank.

Any help would be great. Thank you all.

--
Scot Rawlings
Technical Trainer
Comcast
Auburn, WA

Message posted via AccessMonster.com

 

[Klatuu]

IIF([Current CommTech Level] = [CommTech 1], [Date of Last Promotion] =
DateAdd("d", 90, [Date of Last Promotion]), Null)

BTW, spaces in names are not a good idea. names should be limited to
letters, numbers, and the underscore character. They should also not be
reserved words like Date, Time, Hour, Descripton, Name, etc)

 

[spcscooter via AccessMonster.com]

Thank you very much for your help.

IIF([Current CommTech Level] = [CommTech 1], [Date of Last Promotion] =
DateAdd("d", 90, [Date of Last Promotion]), Null)

BTW, spaces in names are not a good idea. names should be limited to
letters, numbers, and the underscore character. They should also not be
reserved words like Date, Time, Hour, Descripton, Name, etc)

I am in the need of an IIF statement. I am looking to do the following:

If the field [Current CommTech Level] equals CommTech 1 then add 90 days to
the field [Date of Last Promotion]. If not then the field is blank.

Any help would be great. Thank you all.