Multiple iif expession question

[chef_tim]

Good morning, I'm working on a weapons qualification report. We have 3 catagories ABC which shot at different intervals. I've got group A figured out =IIf([ARMING GROUP]="GROUP A",[M16QUAL]+365) I need to know how to add two more expressions just like that but adding two and three years respectively. I've tried alot of combinations, but I think I am just missing the transition from one to the next. Hope this makes sence . Thanks for the help, Tim

 

[allan57]

Try this:-

IIf([ARMING GROUP]="GROUP A",[M16QUAL]+365, IIf([ARMING GROUP]="GROUP B",[M16QUAL]+730, IIf([ARMING GROUP]="GROUP C",[M16QUAL]+1095, 0)))

If no valid [ARMING GROUP] (ie A, B or C) then returns 0

 

[chef_tim]

Hi Allan, that is giving me a "syntax error (comma) in query expression". Thanks, Tim

 

[Ukraine82]

Put an equal sign before =IIf([ARMING GROUP]="GROUP A",[M16QUAL]+365, IIf([ARMING GROUP]="GROUP B",[M16QUAL]+730, IIf([ARMING GROUP]="GROUP C",[M16QUAL]+1095, 0)))

hth,
Michael

 

[chef_tim]

Wow, that did it. Thanks guys, Tim