Big Query Problem

[a]

Big Query Problem

I have This Fields In table1 (Design View)

ID Autonumber PrimaryKey

ClientName Text

ClientGroup Text



Data Sheet View

Id ClientName ClientGroup

1 A 1

2 b 1

3 A 2

4 B 1

5 C 1

6 A 3

7 B 1



I have Query:



SELECT Table1.ClientGroup, Table1.ClientName

FROM Table1

WHERE (((Table1.ClientGroup)="1") OR ((Table1.ClientName)="a")) OR
(((Table1.ClientName)="b"));



My Problem:

The search result give me bad result I don't know I tell the query give me
the clientgroup (1) and clientname (a or b)

The search result give me (ClientGroup 1 and 2) I don't want 2



Query1

ClientGroup
ClientName

1
a

1
b

1
c

1
a

1
a

2
b

2
a

2
a

2
a




This is very big problem:

 

[Abu]

SELECT Table1.ClientGroup, Table1.ClientName
FROM Table1
WHERE (((Table1.ClientGroup)="1") AND (((Table1.ClientName)="a")) OR
(((Table1.ClientName)="b")));