Thread: Compile Error
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
CurtH CurtH is offline
external usenet poster
 
Posts: 26
Default Compile Error

Okay. I understand now. Thanks!

"CurtH" wrote:

Meaning that I should use them? What you insert looks exactly like the
original code.

"bpeltzer" wrote:

"WHERE (((UNIT)='125 LOGISTICS READINES SQ') AND ((IMR Action
Items" )= 'Y')); "

The double-quotes aren't paired in this WHERE clause...

"CurtH" wrote:

I get this compile error with syntax. Code is:

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