Not good with IIF statements

  • Thread starter Thread starter spcscooter via AccessMonster.com
  • Start date Start date
S

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
 
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)
 
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.
Click to expand...
Click to expand...
 
Back
Top