A "for all" query in MS Access?

SELECT tblEquipmentGroups.GroupTagNumber, tblEquipment.LocationCode
FROM tblEquipmentGroups, tblEquipment, tblLookUpGroups
WHERE tblEquipmentGroups.GroupTagNumber = tblLookUpGroups.GroupTagNumber
  AND tblEquipment.TagNumber = tblLookUpGroups.TagNumber
GROUP BY tblEquipmentGroups.GroupTagNumber, tblEquipment.LocationCode

SELECT GroupTagNumber
  from tblLookUpGroups lg
 where not exists(select * 
from tblEquipment te
 where te.TagNumber = lg.TagNumber
   and location_code <> <userGivenValue>)

SELECT tblEquipmentGroups.GroupTagNumber
FROM tblEquipmentGroups INNER JOIN (tblEquipment INNER JOIN tblLookUpGroups ON tblEquipment.TagNumber=tblLookUpGroups.TagNumber) ON tblEquipmentGroups.GroupTagNumber=tblLookUpGroups.GroupTagNumber
GROUP BY tblEquipmentGroups.GroupTagNumber
HAVING (((Avg(tblEquipment.LocationCode))=[Enter Location Code]));