Multiple HAVING in query

[tagteam]

I have the query

SELECT tbl_ImportedRepairs.InvoiceNumber
FROM tbl_ImportedRepairs


WHERE tbl_ImportedRepairs.TrinityBatch IS NULL
GROUP BY tbl_ImportedRepairs.InvoiceNumber
HAVING (((Sum(IIf([BlakeApproval]=False,1,0)))=0));

This query finds line items in a table and gives me the invoice number ONLY if all the line items have been approved.

I would like to build on that and say:
Give me Invoice Number if ALL line items have been approved
AND
All The Updated Responsibility code are 1

I am thinking it might be like this

SELECT tbl_ImportedRepairs.InvoiceNumber
FROM tbl_ImportedRepairs
WHERE tbl_ImportedRepairs.TrinityBatch IS NULL
GROUP BY tbl_ImportedRepairs.InvoiceNumber
HAVING (((Sum(IIf([UpdatedResponsibilityCode]=1,1,0)))=0)) AND HAVING (((Sum(IIf([BlakeApproval]=False,1,0)))=0));

But of course that doesnt work and I am getting
Syntax error (missing operator) in query expression '(((Sum(IIf(BlakeApproval=Flase,1,0)))=0)) AND'

[June7]

Try only 1 HAVING.

HAVING (((Sum(IIf([UpdatedResponsibilityCode]=1,1,0)))=0)) AND (((Sum(IIf([BlakeApproval]=False,1,0)))=0));

[Bob Fitz]

The error msg posted has a "AND" at the end but I can't see that in the posted SELECT statement. If it is actually in the SELECT statement, remove it. Also not sure that the second "HAVING" is required.
EDIT
Sorry, it would appear that I took to long to write this post. Got a bit distracted by the football on TV.

[tagteam]

Yes, I am having as hard a time with this query as Germany is with Algeria. I will try it without the two Having and see.

Edit, I got distracted too

It runs if I take out the second Having but does not return the desired result. I ran it with an invoice where they were all approved and were all UpdatedResponsibilityCode of 1 and it didnt show up.

[tagteam]

Spoke too early. Had to change the UpdatedResponsibilityCode = 1 to UpdatedResponsibilityCode <> 1.

Looks good but will have to do further testing tomorrow.
Thanks