Hi and TIA!
I have a recordset like so:

COG MCC
9G D
7R E
9N (null)
1R D
1R (null)
3R D
3R (null)
1N D
1N (null)
3N D
3N (null)
etc.....

What I want is to return all records except where COG is "1*" or "3*" and
MCC Is Not Null like so:

COG MCC
9G D
7R E
9N (null)
1R (null)
3R (null)
1N (null)
3N (null)
etc.....

I've tried every combination I can think of, but can't seem to achieve my
goal. This also needs to be an editable recordset returned. Any advice is
appreciated!

Ooops! I said where MCC is not null below, but meant to say where MCC Is
Null!
"Reggie" <NoSpam_chief123101 (AT) NoSpam_yahoo (DOT) com> wrote

I stand corrected again! My original post was correct. Really sorry about
this. It's 2am so I guess I should call it a night before I recall get
screwed-up. Thanks again for your patience.
"Reggie" <NoSpam_chief123101 (AT) NoSpam_yahoo (DOT) com> wrote

Reggie

In the query criteria for COG is:
Not Like "1*" And Not Like "3*"

For MCC:

Not Is Null

This will do it.

Good Luck
Ira Solomon


On Tue, 17 May 2005 02:08:07 -0700, "Reggie"
<NoSpam_chief123101 (AT) NoSpam_yahoo (DOT) com> wrote:

Ira, Thanks works great. I had to add OR MCC Is Null otherwise I didn't
get the COG's with a Null MCC.

SELECT [1_NC_Analysis].OS_COG, [1_NC_Analysis].OS_MCC
FROM 1_NC_Analysis
WHERE ((([1_NC_Analysis].OS_COG) Not Like "1*" And ([1_NC_Analysis].OS_COG)
Not Like "3*") AND (Not ([1_NC_Analysis].OS_MCC) Is Null)) OR
((([1_NC_Analysis].OS_MCC) Is Null))
ORDER BY [1_NC_Analysis].OS_COG;

Thanks again!!


"Ira Solomon" <isolomon (AT) solomonltd (DOT) com> wrote