Name search in multiple fields

[eholtman]

I am trying to build a query that if "Name" matches either "Submitter", "Requester", or "Implementor" then it shows. For some reason I am only getting if it equals all 3. I am looking if it equals at least one then show. Not sure if I have to show my properties differently or command in my query.

TIA...

 

[DCrake]

Try

In("Submitter", "Requester","Implementor")

 

[eholtman]

D,

Thanks for the response. I feel like a idot now you give me a answer and now I have to ask for more understanding. When you say

In("Submitter", "Requester","Implementor")

Are you in design view or SQL view. If in Design view where do I have input the string. Right now I have in my design vew the Name Table and another table with the Submitter, Requester, and Implementor fields. When I try to show properties to more than one table (ie. Name=Submitter and Name=Requester, or Name=Implementor) it is showing that it must match all three to show.

Seems simple but I have searched and played and I now in a corner.

 

[rainman89]

You can do it in design view

Also: I hope Name is not the actual name of your field. You should change it since that is a reserved word.

 

[eholtman]

Alright I have invested time and still not any farther so I created a sample database any help will be appreciated. Banging the head against the wall. I am going to try to explain because I am not finding any easy way to get this accomplished.

You will see two tables one with Employees (tbl Full Name) then I have a work numbers table that the employee could be a Submit or Requester, or Implement. As you can see in Part #1 on my quieries that I continue to get dublicates if the three categories are not the same as in work order #12 A is the Submit B is the Requester C Implement. Seems to work other than the issue of dublication. I only want to see the record once.

Query Part II - I now want to show the manager if they were a submit, requester, or Implement. If it did not match then blank but that also is not being carried over.

Again any help is appreciated.

 

[rainman89]

You have no way to link between the employee table and work numbers table in part 1 thats why you are getting duplicates... you would need to change it to something like

SELECT [tbl Work numbers].[Work ID], [tbl Work numbers].Submit, [tbl Work numbers].Requester, [tbl Work numbers].Implement
FROM [tbl Work numbers]
WHERE ((([tbl Work numbers].Submit)="a")) OR ((([tbl Work numbers].Requester)="a")) OR ((([tbl Work numbers].Implement)="a"));

Same with part 2.