Sep 25 2007, 02:26 PM
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.
Sep 25 2007, 02:35 PM
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.
Sep 25 2007, 02:42 PM
Now I get to sound really stupid but where do I put that expression ?
Sep 25 2007, 02:46 PM
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.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here