I am working on a text box that will check if ALL of the field values for a particular EmployeeID are the same, if they are display one status message, if they are not, display a different status message.
It's an employee tracking database for our companies safety training program. Each employee has many different types of training. I would like this text box to look and see if all of the field values [CompletionStatus] of a certain EmployeeID are "Complete". If this is true, then display "Training Complete", if not display "Training Incomplete".
I am not sure which function I need to use to do this.....
Here's what I am thinking:
=IIf(DLookup("CompletionStatus","tblTrainingTypes" ,"EmployeeID = " & Forms![frmEmployees]!EmployeeID)="Complete","Training Complete","Training Incomplete")
How far off am I? lol The statement above I would assume will only check the first record and not all of them, is there a different function that I should be using?