Mail Merge

[Guest]

I am using a mail merge in word, but i am getting a database error. I dont
recall changing anything in the database since the last time i used the merge
and i had no problems then. When i run the merge, it stops after record
number 42, and an error pops up in access. The error i get is:

Run-time error '-2147217900 (80040e14)':
Syntax error (missing operator) in query expression 'Supplier_ID ='.

 

[Douglas J. Steele]

Is it possible that record number 42 doesn't have a value for Supplier_ID?

 

[Guest]

it does, and thank god. if that was the problem i would feel like a real
idiot. any other suggestions? like i said it was working last time i used
it, but now it isnt.

 

[Guest]

i should also note that the query works perfectly fine in access and returns
all the correct information.

 

[Guest]

Actually, i have tested the query again. I thought that i worked fine, but
as i started to scroll i recevied the same error. It appears that in one of
my fields i get an error because it cannot find the value that is supposed to
be there. However there isnt supposed to be a value there becuase it is a
null. This isnt the only null in the table which is why i dont understand
why only this one record isnt working.

 

[Guest]

Ok, problem solved. I used the concatenation function and i think that
because the value in one of the fields that were being concatenated was null,
an error was given. i simply placed in a value and it worked.