Need Help With Small Code . .

[Evagrius]

Hi, I have the below sql in code. I've been tring to add a line where [building Number] is NOT NULL - but I can't seem to get it right. I created a query and tried to copy it - but my syntax is incorrect. I would be grateful for any help!! Thank you!

Rem POPULATE BUILDING LIST BOX BASED ON ORG CODE
strSource = "SELECT [Building Number] " & _
                   "FROM tblRatio " & _
                   "WHERE [Organization] = '" & Me.ListOrgCode & "' GROUP BY [Building Number] ORDER BY [Building Number]"

 

[boblarson]

"SELECT [Building Number] " & _
"FROM tblRatio " & _
"WHERE [Organization] = '" & Me.ListOrgCode & "' And [Building Number] Is Not Null GROUP BY [Building Number] ORDER BY [Building Number]"

 

[Evagrius]

Thank You Bob!!