Hello All, Thanks for the help
Basically I have 4 different classes that a Manager can take and to be cosidered "Complete" they have to complete 2 out of the 4. Any combination at any time. I know I would be using an If Statement, but i am not sure what direction to go in. any suggestions?
here is what I am thinking.
IIf([Job Category]='Manager' And [Course] In ('3L00643','L00640','L00641','L00642') Here is where i get stuck. i want to say something like And If the person has completed two or more out of the four classes, show the max date of the classes they have completed.
any suggestions? anything i can look up if this has been covered before?