Not good with IIF statements

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

spcscooter via AccessMonster.com

I think I found out where I explained myself wrong. Can someone help.

I need an IIF statement for the following...

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

Sorry for any confusion on an earlier post.

Thank you

--
Scot Rawlings
Technical Trainer
Comcast
Auburn, WA

Message posted via AccessMonster.com
 
Then just modify the solution that Dave Hargis provided like this;

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

You'll have to adjust for the line wrap.
 
Back
Top