Word 2000 mail merge error

[mika.]

Hello,

I have a mail merge set up in word with an XL2000
spreadsheet as the data source. For some reason, on one
field, whenever i try to set the query options to sow
records where a particular field equals TUTORIAL 1, I get
the error "Word could not pass your query options into a
valid SQL string." I can't see any reason why my query
would not work. Any ideas?

Thanks.

 

[Peter Jamieson]

The chances are that Word has misinterpreted the data type of your column.
This definitely can happen. Word will generate SQL code such as

WHERE myfield = TUTORIAL 1

instead of

WHERE myfield = 'TUTORIAL 1'

and when it actually tries to execute the code it generated, the syntax
error will appear.

The questoin in each case is what causes that to occur. It could happen if
for example Word has decided that the data type of the column containing
your "TUTORIAL 1" text is numeric. That /might/ happen if for example the
values in that column in the first few rows were all numbers, or if you had
changed the column and not gone through the process of connecting to the
data source again.