If records in rows a and b are equal then

[dbertanjoli]

Hello,
I would like to show records in my query only if records in raw a and b are equal and they have same question id.
Please let me know if you can help.
Many thanks,
Debbie

 

[Mike375]

NewFieldName: IIf([a]= And [aQuestionID]=[bQuestionID],"Same",Null)

Replace "same" and Null with whatever like.

Then on the calculated field NewFieldName enter on the Criteria row Like "Same" or whatever you have selected for the true answer from IIF

 

[ajetrumpet]

As a follow-up to Mike's "semi" answer, here is the SQL for the request:

SELECT *
   FROM table
      WHERE [a] = [b] AND 
         [question ID] IN (SELECT [question ID]
      FROM table
   GROUP BY [question ID]
HAVING COUNT(*) > 1)

 

[dbertanjoli]

Many thanks, I don't know what I would do without Access Programmers Forum.
Deb