If the error is just building the string, then perhaps:
Tested from the immediate window:

Src = "SELECT * " _
& "FROM MedicalStatus " _
& "WHERE (((UNIT)='125 LOGISTICS READINES SQ')" _
& " AND ((IMR Action Items)='Y')); "



--
Regards,
Tom Ogilvy


"CurtH" wrote in message
...
I get this compile error with syntax. Code is:

Src = "SELECT * " _
& "FROM MedicalStatus " _
& "WHERE (((UNIT)='125 LOGISTICS READINES SQ') AND ((IMR Action
Items" )= 'Y')); "