query not working-urgent

[Guest]

select sales from customer having [cust] not in
("john", "mry");

Please help

 

[Tom Ellison]

Dear Murray:

SELECT sales FROM customer WHERE cust NOT IN ("john", "mry");

I don't know the environment in which you expect this to work (your
table and columns and what values they may have) but HAVING is not
meant for this context.

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts

 

[Guest]

Tom

Where-does not work either. And, cust is text, "where
cust in ("john") works but gives me a mismatch error if I
use not in.

Please help...I have been butting my head against this for
a long time.

Thanks

-----Original Message-----
Dear Murray:

SELECT sales FROM customer WHERE cust NOT IN ("john", "mry");

I don't know the environment in which you expect this to work (your
table and columns and what values they may have) but HAVING is not
meant for this context.

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts

select sales from customer having [cust] not in
("john", "mry");

Please help

.

 

[Rick B]

Why not use...

SELECT sales FROM customer
WHERE (((cust) Not Like "*john*" And (cust) Not Like "*mary*"));


Rick B

Tom

Where-does not work either. And, cust is text, "where
cust in ("john") works but gives me a mismatch error if I
use not in.

Please help...I have been butting my head against this for
a long time.

Thanks

-----Original Message-----
Dear Murray:

SELECT sales FROM customer WHERE cust NOT IN ("john", "mry");

I don't know the environment in which you expect this to work (your
table and columns and what values they may have) but HAVING is not
meant for this context.

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts

select sales from customer having [cust] not in
("john", "mry");

Please help

.