Recent content by kylem4711

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...

sorry i must be terrible at explaining stuff. this is my though process of what im trying to say. If you are a manager, and you have taken the WBT and Mgr, then show me the last completion date of the two courses (Wbt, Mgr) if not, then leave blank. when I am trying to create is a...

that is actually it, 3L00643 WBT is a course that a manager would take so it only contains dates. The same is for L00641 Mgr. this works, But I wanted to have L00641 Mgr and 3L00643 WBT as a possible output values and be able to get the max of those two classes is they both are...

sorry, it actually just said there was a syntax error (comma) in query expression. error 3075 But i can not remove any of the commas

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?

one of the problems that i am having deals with the Employee, it shows that they have taken a class L00641 Mgr, but it does not show the completion date in the column. it also does not list the later date in the completion date. I try to set it to max, but then it gives me an error? so...

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...

fifa may be a little old now. but it is still a great game!