Search results
-
K
Help With an expression
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... -
K
Max Query, Why doesn't this work?
basically, i am trying to say, if a Manager has taken 3L00643 WBT and L00641 Mgr, then show the max of those two dates. Can anyone help? -
K
IFF and Null Criteria Help
Hello All, Thank you for anyone that is willing to help. Basically, i am trying to create a "complete" column but am having trouble. Can anyone notice any problems with this code? Complete: IIf([Job Category]='Employee' And [L00642 Emp] Is Not Null,[L00642 Emp],IIf([Job...