i have made my report and in a text box i want to write in the control source:

surname where shift = morning


i want to display a surname where the shift field is equal to "morning"

OnFormat Event....
If [Shift]= "Morning" Then
[MyUnboundField]=[Surname]
End If

HTH