Query Multiple Criteria from Same Column
Posted on 2007-07-30
I have a MS Access table to store a Staff Code (StaffCode) and Operating Unit Code (OuCode). Basically, this is how my datas would look like in the table (StaffOu).
StaffCode (String) OuCode (Integer)
As u can see from my table, the StaffCode and OuCode combination is a unique entry. My question is, how can i query for the Staffcode(s) to select those records with both OuCode 1 and 2 present. This is what i've done so far and it returned an empty result.
WHERE OuCode=1 AND OuCode=2;
Hope to find the right SQL syntax for this. Thanks.