Not like query criteria

  • Thread starter Thread starter DBM
  • Start date Start date
D

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.
 
Please post the SQL statement of your query.

Regards

Jeff Boyce
Microsoft Access MVP
 
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*"));
 
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

DBM said:
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*"));



Jeff Boyce said:
Please post the SQL statement of your query.

Regards

Jeff Boyce
Microsoft Access MVP
Click to expand...
Click to expand...
 
Back
Top