I am using Word to generate labels from an Excel datasource which I have done
successfully before.
This time I would like to filter about 5,000 records to print only customers
in County Durham with a Yes in the Catalogue column and a blank entry under
the Account No. column.
I can edit to show only County Durham customers and County Durham customers
with a Yes, but when I try and filter out those customers with an entry in
the Account No. column it all goes wrong!  It seems to ignore the filter and
shows all customers.
I have tried clicking on the arrows in the column headers and clicking on
(Blanks), I have also tried clicking on Advanced and entering my criteria
here.  What is really odd is that when I try to get the blanks up, when I
look in Advanced it duplicates the blank criteria and I can have two or three
or four lines with it saying Account is blank and usually its got an OR in
there too which could be the cause for confusion but I don't know why its
doing it!
Any ideas as I am now completely stuck?!