Forgive me if this has already been addressed somehow, but I've searched for far too long and it's just time to ask the question: I have a query that I'm updating, and it's written in SQL (not my strong-suit!). I've been able to make some limited updates, but when I get to the final step I get the following error:

Syntax Error in Query Expression SELECT 'OLD NUMBERS: '& Count([MissingDocsUnresolved].[loan_id]) & ' / (' & (SELECT Count(dbo_cs_loan_balances.loan_id) & ' - ' & (SELECT FormatNumber(Count(dbo_cs_loan_misc_fields.loan_id),0)))


I got to this point by replacing old code with updated code that works separately just fine. My first replacement (Count([MissingDocsUnresolved].[loan_id])) worked just fine inside the old code, but when I put in my second replacement ((SELECT FormatNumber(Count(dbo_cs_loan_misc_fields.loan_id)) that's when I get the error.

Any ideas?

Here's the whole thing:
SELECT 'OLD NUMBERS: '&
Count([MissingDocsUnresolved].[loan_id]) & ' / (' &
(SELECT Count(dbo_cs_loan_balances.loan_id) & ' - ' &
(SELECT FormatNumber(Count(dbo_cs_loan_misc_fields.loan_id),0)))

FROM dbo_cs_loan_misc_fields
WHERE (((dbo_cs_loan_misc_fields.misc_dt_value) Between DateSerial(Year(Date()),Month(Date())-6,1) And DateSerial(Year(Date()),Month(Date()),0)) AND ((dbo_cs_loan_misc_fields.misc_field_id)=10121)

FROM dbo_cs_loan_balances
WHERE dbo_cs_loan_balances.loan_id>10
AND dbo_cs_loan_balances.prin_bal>0) & ')' AS Answer

FROM MissingDocsUnresolved LEFT JOIN NL_DtComplete ON MissingDocsUnresolved.loan_id = NL_DtComplete.NewLoanID
WHERE (((NL_DtComplete.Complete) Is Null))


Thanks so much for your help!