Hi Bob,

Also another way is:

SELECT *
FROM ThisTable
WHERE ThisTable.Status = "Urgent" AND ;
ThisTable.LeadConsultant in ("Smith","Jones")

That way you could have more than 2 options on the lead consultant.

Hope this helps.

Tim