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.

You probably have SQL that looks like:

WHERE manager = "Paul" AND detailer= "Paul"

and you want

WHERE manager = "Paul" OR detailer= "Paul"

Note the OR instead of AND. In the query design grid, you'd want them on different rows instead of the same row.

Now I get to sound really stupid but where do I put that expression ?

You said you had something that worked, but only if both had the same name. I assume that "something" is a report based on a query with criteria in it. Look at that query.