Problem with blank entries being filled with other values

Hello


Using Office 2002 SP-2, Windows 2000 V5.0 SP-4.

One of my users set up a mailmerge document for printing labels and has
been using this successfully with an Access table created using a Make
Table query. Originally the table used to create the mailmerge table was
an Access table but, due to corruption problems, we had to move it out to
SQL Server 2000.

The Make Table query still runs successfully, producing a correct table.
The problem is that, when the user merges this table to Word, empty values
in the Counter field are replaced with values from this field in other
records. e.g. the last value in the Counter field is 7625, so all records
that do not contain a value in the Counter field are given the value 7625
as well.

I have checked the data source from within Word and the result set looks
normal, i.e. the blank values are blank. however, when you actually run
the merge, Word is refusing to allow these fields to stay blank on the
document.

This problem only began appearing after we changed to a SQL Server table.
The resulting table from the query is still an Access table but now the
merge misbehaves. The Counter field has a numeric type in SQL and a number
type in the resulting Access table.

If anyone has any suggestions I'd be very grateful.

Many thanks

Denise Crawley
.

Relevant Pages

  • Re: Problem with blank entries being filled with other values
    ... We have a table in SQL Server ... We run a Make Table query within Access, which produces a table in Access ... The connection via DDE worked. ... >> in the Counter field are replaced with values from this field in other ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Problem with blank entries being filled with other values
    ... You have a table in SQL Server 2000. ... Then you use a make table query in Access to create a table in Access. ... Or are you managing to use the Make table query as the data source for the ... > in the Counter field are replaced with values from this field in other ...
    (microsoft.public.word.mailmerge.fields)