Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Queries / February 2008

Tip: Looking for answers? Try searching our database.

Big Query Problem

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
a - 18 Feb 2008 19:23 GMT
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 - 18 Feb 2008 21:42 GMT
SELECT Table1.ClientGroup, Table1.ClientName
FROM Table1
WHERE (((Table1.ClientGroup)="1") AND (((Table1.ClientName)="a")) OR
(((Table1.ClientName)="b")));
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.