I have a table called projects. In that table there is a field for manager and a field for detailer. I have another table for our employees. Now what I am trying to accomplish is to make a report that will look at both fields and show the project if a persons name is in either the mangers field or the detailer field. It works if both are the same name but not if the person is in one or the other.

This has been kickin my butt so thanks for any help you can give.