Mail Merge SQL

[rookery]

Not certain this is the correct forum but can anyone tell me why the following code:

SQLStatement:="SELECT * FROM [Contacts] WHERE [Surname]= '" & Spires & "' "

within a OpenDataSource command produces a 5631 "..no records.." error and yet:

SQLStatement:="SELECT * FROM [Contacts] WHERE [CustID]=459"

doesn't. It seems as though it works for Number fields but wont search for Strings. Is this meant to do this or have I done something wrong?

 

[rookery]

Ah different data types! Easy when you know how!