A
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:
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: