Re: MailMerge Query Discontinuity

From: Peter Jamieson (pjj_at_KillmapSpjjnet.demon.co.uk)
Date: 07/24/04 

Date: Sat, 24 Jul 2004 11:32:04 +0100

What is the data source, and what type of data (text, integer) is causing
the problem?

Generally speaking my experience is that many applications either convert
nulls to blanks/zeroes etc., depending on the data type, and/or confuse
nulls, zeros and blanks. Neither Word nor MS Query seems to be an exception,
e.g. I just set up a SQL Server table with some null values and displayed
the data in MS Query. Whereas SQL Server can, for a text column, distinguish
between null and blank, MS Query shows no sign of recognising any values
(text or numeric) as null, and no way of entering nulls either.

What end result are you trying to achieve? DO you need nulls to appear as
blanks? Should numeric nulls appear as 0 or blank? Are you trying to filter
on the basis of null values? 

-- 
Peter Jamieson
"Ken" <Ken@discussions.microsoft.com> wrote in message
news:369D9B44-9943-4914-B05F-1DF1F684B5C4@microsoft.com...
> A MailMerge query runs correctly and the resulting rowset can be observed
in the
> Word 2003 MailMerge Recipents list. However it contains columns with Null
values.
>
> When the MailMerge Recipents form's Edit control is clicked, the same
query result is displayed via a DDE link to Micrsoft Query. The rowset
displayed by MS Query contains NO Null columns. When  'Return Data to
Micrsoft Word' is selected from Query's File menu, the Recipents list still
contains the Null columns.
>
> How should I approach this problem - I found nothing specific to this
symptom in the KB. Thanks,
>
> Ken

Relevant Pages

  • Re: Figuring out what field is causing key violation on append
    ... Nz converts nulls to whatever you put as the second argument. ... Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia ... First try the query with just one field in the append query. ...
    (microsoft.public.access.queries)
  • Re: Median
    ... so the nulls may be being re-introduced to the ... Run your XPercentile function and your query against that. ... I have not personally used this median function... ... Candia Computer Consulting - Candia NH ...
    (microsoft.public.access.reports)
  • Re: Figuring out what field is causing key violation on append
    ... the fields to not allow nulls any longer. ... First try the query with just one field in the append query. ... .......(all other than key violations is 0) ...
    (microsoft.public.access.queries)
  • Re: MailMerge Query Discontinuity
    ... when I run the query with QA or Access or MS Query there ... is the Doctor control table had a few rows added, growing in size from 60 to ... > CorStatDataOP.dbo.Pacemaker Pacemaker, ... >> nulls, zeros and blanks. ...
    (microsoft.public.word.mailmerge.fields)
  • Re: MailMerge Query Discontinuity
    ... could the data type of the "doctor" columns also have been changed? ... when I run the query with QA or Access or MS Query there ... > CorStatDataOP.dbo.Pacemaker Pacemaker, ... >> nulls, zeros and blanks. ...
    (microsoft.public.word.mailmerge.fields)