One of my SQL Conditions is being ignored

[nick]

The ((Approvals.Approval_Action) Like "Given") isn't doing anything. Am I
doing something wrong?

SELECT *
FROM Approvals
WHERE Approvals.Approval_Date IN (Select MAX (Approval_Date)
FROM Approvals
WHERE (((Approvals.Approval_Action) Like "Given") AND
((Approvals.Quote_Number) Like
[Forms]![Quote_Invoice_Manager]![Quote_Invoice_ID])) AND
(Approvals.Approval_Level Like 2));

 

[Duane Hookom]

Normally, you should encorporate "*" with "Like".
Like "*Given*"

--
Duane Hookom
MS Access MVP

The ((Approvals.Approval_Action) Like "Given") isn't doing anything. Am I
doing something wrong?

SELECT *
FROM Approvals
WHERE Approvals.Approval_Date IN (Select MAX (Approval_Date)
FROM Approvals
WHERE (((Approvals.Approval_Action) Like "Given") AND
((Approvals.Quote_Number) Like
[Forms]![Quote_Invoice_Manager]![Quote_Invoice_ID])) AND
(Approvals.Approval_Level Like 2));

 

[Douglas J. Steele]

I don't believe that Like works with numbers, just with text.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

The ((Approvals.Approval_Action) Like "Given") isn't doing anything. Am I
doing something wrong?

SELECT *
FROM Approvals
WHERE Approvals.Approval_Date IN (Select MAX (Approval_Date)
FROM Approvals
WHERE (((Approvals.Approval_Action) Like "Given") AND
((Approvals.Quote_Number) Like
[Forms]![Quote_Invoice_Manager]![Quote_Invoice_ID])) AND
(Approvals.Approval_Level Like 2));