Query with Where (Multiple Selections)

[braveali]

Hi,

I have a list of codes that I would like to select among 50,000 codes in MS Access Database:
I can easily find one code but I don't know how to select multiple values:

My Query is:

SELECT [Codes for District].DistrictID, Univ2012.Schoolid

FROM Univ2012 INNER JOIN [Codes for District] ON Univ2012.DistrictID = [Codes for District].DistrictID

WHERE IN [((Univ2012.Schoolid)= 415030301, 415030303, 415030306, 415030309)]

GROUP BY [Codes for District].DistrictID, Univ2012.Schoolid

HAVING ((([Codes for District].DistrictID)=15));


when I run this query it gave me Syntax Error in Where clause...



I will appreciate your help to resolve my problem.

Thanks

Regards

[recyan]

Offhand have you tried,
WHERE Univ2012.Schoolid IN (415030301, 415030303, 415030306, 415030309).

Thanks

[braveali]

its work perfect

Thanks

Cheers!

[recyan]

Glad you got it working.

Thanks