Urgent Two Criteria query.. help

[paddydive]

Hi,

I am using Access 2010. I have a query which is pulling data from multiple tables.

One of the table "Project" has field as Client Rank and Watch list.

Client Rank field has Ranks for a particular client and Watch List field has Yes/No

What I Need :

I need a query which will give me records for which Watch list is "Yes" and below that records with Client Rank less than 51

Note : The Watch list record are irrespective of client rank.

In short : I need all records with Watch List as Yes (Above) and all records where client rank is less than 51 (Below)

Please help

 

[mole999]

Haven't used access for ages but in SQL which has similarities

Select *
From Project
Where project.Watch List = 'Yes'
And project.Client Rank < 51
Order by project.client rank desc

does that help ?

 

[paddydive]

But that will pull records where Client Rank is less than 51

The Watch List should be irrespective of Client Rank

 

[mole999]

ah so

Select *
From Project
Where project.Client Rank < 51
Order by project.client rank desc

desc should then sort alphabetically and desc should make it Y followed by N

 

[paddydive]

Thanks Mole for taking trouble for this !!

Sorry but that will pull records where client rank < 51.

Let me explain what i need

1) Records where Watch list is Yes (irrespective of Client Rank, this will include all the records where Watch list is Yes, no matter what is client Rank)
2) All the records where client rank < 51

 

[mole999]

light bulb

Select *
 From Project
 Where project.Watch List = 'Yes'

[B]UNION[/B]

Select *
 From Project
 Where project.Client Rank < 51
 Order by project.client rank desc

 

[paddydive]

Thanks.. I will give it a try...

Thanks for taking trouble and answering it

 

[mole999]

fingers crossed