Not like query criteria

[DBM]

I'm having trouble trying to filter out multiple data from a field using the
Not Like criteria. Any criteria I enter not in the top criteria row appears
in the query results.
Thanks in advance.

 

[Jeff Boyce]

Please post the SQL statement of your query.

Regards

Jeff Boyce
Microsoft Access MVP

 

[golfinray]

You can try Not like this OR not like that OR not like the other.

 

[DBM]

SELECT tbl_CSAs_by_PRS.[Client ID], tbl_CSAs_by_PRS.[Date Created],
tbl_CSAs_by_PRS.Class, tbl_CSAs_by_PRS.Priority, tbl_CSAs_by_PRS.Description,
tbl_CSAs_by_PRS.[Created By]
FROM tbl_CSAs_by_PRS
WHERE (((tbl_CSAs_by_PRS.Description) Not Like "*Backdated Payroll*" Or
(tbl_CSAs_by_PRS.Description) Not Like "*ACCOUNT ON AR*"));

 

[Gina Whipp]

DBM,

Try putting both on the same line with *AND* and not *OR*. (Don't use the
asterisks!)

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

SELECT tbl_CSAs_by_PRS.[Client ID], tbl_CSAs_by_PRS.[Date Created],
tbl_CSAs_by_PRS.Class, tbl_CSAs_by_PRS.Priority,
tbl_CSAs_by_PRS.Description,
tbl_CSAs_by_PRS.[Created By]
FROM tbl_CSAs_by_PRS
WHERE (((tbl_CSAs_by_PRS.Description) Not Like "*Backdated Payroll*" Or
(tbl_CSAs_by_PRS.Description) Not Like "*ACCOUNT ON AR*"));

Please post the SQL statement of your query.

Regards

Jeff Boyce
Microsoft Access MVP