SQL Statement syntax error

[starclassic]

Not sure whats wrong with the statement..

StrSql = " SELECT *" _
& "FROM tblContact " _
& "WHERE tblContact.OtherExplain Is Null " _
& "And tblContact.GComments Is Null" _
& "And tblContact.ByPhone = 0" _
& "And tblContact.LeftMessage = 0" _
& "And tblContact.Promise = 0" _
& "And tblContact.Other = 0" _
& "And tblContact.ContactNumber = 1" _
& "And tblContact.FollowUpDate Between #" & Format(Forms!frmQueue!txtFollowUpDateStart, "mm/dd/yyyy") _
& "# And #" & Format(Forms!frmQueue!txtFollowUpDateEnd, "mm/dd/yyyy") & "# And tblContact.MessageType ='A-306'"

' Syntax Error on Sql statement
Set rst = dbs.OpenRecordset(StrSql)

Any help will do.. Thanks

 

[Ed2020]

Some rows are missing a space at the end (or the beginning of the subsequent row:

StrSql = " SELECT *" _
    & "FROM tblContact "

There is no space after the "*"

Ed Metcalfe.

Please do not feed the trolls.....

 

[starclassic]

Thanks, ED...