Query if record appears for all (PLEASE HELP

[rnc110]

Hi,

I have a table with 2 attributes: Position# and Course#. Currently there are 42 positions (1-42). I need a query to show the course# if that course # appears for all the positions (1-42).


Thank you in advance

 

[Maquis]

You can create a group by query (Sigma symbol on query design toolbar). Group by position, Group by course, count course and display only those records where the count = 42. Maq B-)
<insert witty signature here>