Queries Criteria-Not Like

[Steven P via AccessMonster.com]

Hi,
I'm having trouble with Not-Like. The "types" of machines I wish to exclude
are still showing- eg. hone, 07 K-Land, 08 K-Land, 09 K-Land, 63 T/B etc. The
Periphery Exception is working correctly. I've posted the SQL.
Thanks
SELECT [Inputs Table (MAIN)].DATE, [Inputs Table (MAIN)].[Good Pieces],
[Inputs Table (MAIN)].[103 Machine]
FROM [Inputs Table (MAIN)]
WHERE ((([Inputs Table (MAIN)].[103 Machine]) Not Like "Hone,63 T/B,67 T/B,71
Microflat,07 K-Land,08 K-Land,09 K-Land") AND (([Inputs Table (MAIN)].
[Periphery Exception]) Not Like ("*")));

 

[Aeisedi]

Sorry wrong group, ignore my last post

 

[Duane Hookom]

You would need to use something like:
Not in ("Hone","63 T/B","67 T/B","71 Microflat","07 K-Land","08 K-Land","09
K-Land")

You generally us "Like" with wild cards like
Like "ABC*"
If you don't use * or some other wild card, you might as well use =.

 

[Steven P via AccessMonster.com]

Hi,
Still seeking help with this one.
Thanks

Hi,
I'm having trouble with Not-Like. The "types" of machines I wish to exclude
are still showing- eg. hone, 07 K-Land, 08 K-Land, 09 K-Land, 63 T/B etc. The
Periphery Exception is working correctly. I've posted the SQL.
Thanks
SELECT [Inputs Table (MAIN)].DATE, [Inputs Table (MAIN)].[Good Pieces],
[Inputs Table (MAIN)].[103 Machine]
FROM [Inputs Table (MAIN)]
WHERE ((([Inputs Table (MAIN)].[103 Machine]) Not Like "Hone,63 T/B,67 T/B,71
Microflat,07 K-Land,08 K-Land,09 K-Land") AND (([Inputs Table (MAIN)].
[Periphery Exception]) Not Like ("*")));

 

[Duane Hookom]

Did you see my reply? If it didn't work, please reply with your results.

--
Duane Hookom
MS Access MVP
--

Hi,
Still seeking help with this one.
Thanks

Hi,
I'm having trouble with Not-Like. The "types" of machines I wish to
exclude
are still showing- eg. hone, 07 K-Land, 08 K-Land, 09 K-Land, 63 T/B etc.
The
Periphery Exception is working correctly. I've posted the SQL.
Thanks
SELECT [Inputs Table (MAIN)].DATE, [Inputs Table (MAIN)].[Good Pieces],
[Inputs Table (MAIN)].[103 Machine]
FROM [Inputs Table (MAIN)]
WHERE ((([Inputs Table (MAIN)].[103 Machine]) Not Like "Hone,63 T/B,67
T/B,71
Microflat,07 K-Land,08 K-Land,09 K-Land") AND (([Inputs Table (MAIN)].
[Periphery Exception]) Not Like ("*")));

 

[Steven P via AccessMonster.com]

Duane,
Yes it did work. I did not see your answer until I had re-sent the posting.
Thanks!!

Did you see my reply? If it didn't work, please reply with your results.

Hi,
Still seeking help with this one.

[quoted text clipped - 14 lines]

Microflat,07 K-Land,08 K-Land,09 K-Land") AND (([Inputs Table (MAIN)].
[Periphery Exception]) Not Like ("*")));