Expression trouble

[ROB]

How would the expression read to say If the field [COVERED BY] contained the exact same name as the field [OPERATOR NAME] to display the word "NO" in the field [SPARE] The field operator name is my form control. The other problem is that the field spare is controlled to display yes and no by start and end days attached to the operator name. How would I attach the start and end dates to remove the name from covered by at the same time they expire on operator name.

[NTC]

"start and end days attached to the operator name"
that statement needs some clarity as to what you mean by this...

"How would I attach the start and end dates to remove the name from covered"
another statement that is very difficult to understand

you are in a form? or a query? a simple example would probably help...

[ROB]

SPARE: IIf([Available]=0,"YES!",IIf([C-SITE START DATE]>Date() Or [C-SITE END DATE]<Date(),"YES","NO"))
This is the expression working at the moment in a query. I wish to add that when the field called [covered by] has an employee name contained that matches the name in my [operator name] field to display no in the field called[spare] by the name in [COVERED BY] But the yes and no controls are only operating in the strat and end dates to the field spare