SQL query In Access: help pls

[motaay]

hi

i am tryin to cretae an SQL query in Access which will show me a list of members who have been an officer of at least 3 committes OR events.
The code that i have at the moment is as follows

SELECT DISTINCT tblMember.FirstName, tblMember.Surname
FROM tblMember, [SELECT COUNT(tblEventOfficer.MemberID) AS X, tblEventOfficer.MemberID
FROM tblEventOfficer
GROUP BY tblEventOfficer.MemberID]. AS TEMP1, [SELECT COUNT(tblComOfficer.MemberID) AS Y, tblComOfficer.MemberID
FROM tblComOfficer
GROUP BY tblComOfficer.MemberID]. AS TEMP2
WHERE (X>=3 and tblMember.MemberID=tblEventOfficer.MemberID) OR (Y>=3 and tblMember.MemberID=tblComOfficer.MemberID);



However, this code will only pick up when a member is either an officer of 3 or more committees or 3 or more events. i.e. if a member is an officer of 1 committee and 2 events this is not picked up in the query as it should do


Please could anyone help???


Thanks

 

[aleb]

Table2 - Names
Table3 - commitee member
Table4 - event member

SELECT Table2.First_Name, Table2.Last_Name, Count(Table3.Nameid) AS x, Count(Table4.Nameid) AS y, Count(table3.nameid)+Count(table4.nameid) AS Total
FROM (Table2 LEFT JOIN Table3 ON Table2.First_Name = Table3.Nameid) LEFT JOIN Table4 ON Table2.First_Name = Table4.Nameid
GROUP BY Table2.First_Name, Table2.Last_Name
HAVING (((Count([table3].[nameid])+Count([table4].[nameid]))>=3));

See the screenshot.