Query to list only records containing a word

[esh112288]

I have an image above showing my 2 tables within my query. As you can see, I have 2 fields linked back to the same table, Receiving Area and an Area where Discovered. I did this because they're both the same list of areas.



I'm looking to display all QA records that have a "Value Stream" of Fusion from the Area table. I want it to have this "Value Stream" in either the Receiving Area OR the Area Where Discovered, not both.

Under Area Where Discovered in my Query, I'm writing:

 [Areas]![Value Stream] Like "Fusion"

This is adding a new column to the Query where

 [Areas]![Value Stream] Like "Fusion"

Now it appears that the Query is looking for all records with a Receiving Area AND an Area Where Discovered that have both the SAME Area and Value Stream. Not just the same Value Stream.

How can I write this query to find all QA records with a Receiving Area within Fusion Value Stream OR an Issuing Area within Fusion Value Stream?

Thanks

[June7]

Post the entire sql statement for analysis.

Use wildcard with LIKE operator or just use =.

If you want OR operation then each criteria must be on separate lines of the criteria rows in the query grid.

What do you mean by 'adding a new column'?

[esh112288]

The following is the SQL for the query.

SELECT QA.[QA Number], QA.[QA Type], QA.[Discovered On], QA.Shift, QA.[Discovered By], QA.[Area Where Discovered], QA.[Receiving Area], QA.[Machine ID], QA.[Product Being Rejected], QA.[Date Produced], QA.[Lot Number or Cavity Number], QA.[RBS Die Number or Mold Letter], QA.[Details from Issuer], QA.[Immediate Actions Taken], QA.[Technician Addressing QA]


FROM Areas INNER JOIN QA ON (Areas.[Area ID] = QA.[Area Where Discovered]) AND (Areas.[Area ID] = QA.[Receiving Area])




WHERE (((QA.[Discovered On]) Between Date() & " 6:00:00" And Date()-1 & " 6:00:00" Or (QA.[Discovered On]) Between Date() & " 6:00:00" And Date()-1 & " 6:00:00") AND ([Areas]![Value Stream]="Fusion"));

The AND statement at the end is what needs to be adjusted. Instead of Areas being Fusion, it needs to be that the Value Stream of the Receiving Area = Fusion OR the Value Stream of the Area Where Discovered = Fusion. Disregard the time/date item, that works.

[June7]

Oh boy, think I understand now.

Include Areas table in the query twice, one join on Area Where Discovered field and one join on Receiving Area. The query will show tables Areas and Areas_1.

[esh112288]

Yup that worked perfectly! Can't believe I didn't think of that before. Thanks