query not working-urgent

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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
Click to expand...

.
Click to expand...
 
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
Click to expand...

.
Click to expand...
Click to expand...
 
Back
Top