Thanks Joe. I'm trying to write the sql to complete this task.
I've got
Code:
SELECT 1.*
from (SELECT tblVIP_type.NameID, tblVIP_type.TypeID1, TblMeals.MealName, TblMeals.ID
FROM tblVIP_type INNER JOIN TblMeals ON tblVIP_type.TypeID1 = TblMeals.TypeID
WHERE (((tblVIP_type.NameID)=7))) as 1
where 1.ID Not in
(select MealIDTried
from (SELECT tblJunct.ID, tblJunct.ChoiceNumber, tblJunct.MealIDTried, tblJunct.VIPID_FK
FROM tblJunct
WHERE (((tblJunct.VIPID_FK)=7))))
order by MealName;
but am getting an error "syntax error in 1.ID...…"
Can anyone see where I've gone wrong?