Hi =?Utf-8?B?bWF4LnJhc2JvbGQtZ2FiYmFyZA==?=,

Never used Act. But I know Word interprets "true/false" differently than it used
to. If you place such a field in a merge document, then preview the data, what
values does such a field show for true and false in the document? Chances are,
you have to set the filter to exactly that.

used to be, false was equivalent to 0. But they changed that, probably thinking
that "true/false" or "yes/no" is more intuitive <sigh>

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail :-)

Cindy
The disks used to install the programme are labelled Microsoft Office Xp
Pro, in the word programme that opens it describes itself as Microsoft word
2003  (11.6359.6360) SP1, part of Microsoft Office Professional Edition 2003.

I have created a new word document and used the mail merge toolbar to link
to a database created in access 2000 format (although I have tried with a
brand new dummy version created in access 2003 with the same results and also
an excel spreadsheet).  

Typically my document would look something like this continued down the page:

«Childs_First» «Child_Last» «Roll» «Keyworker» «Next Record»
«Childs_First» «Child_Last» «Roll» «Keyworker» «Next Record» etc

I then click edit recipients on toolbar and go to advanced settings and
choose:
<<Closed>> is blank [This removes children who have already left]
And <<Group>> is equal to <<orange>>
And <<Roll>> is equal to pm [afternoon children only]
Sort by <<Child Last>>

This produces the correct list of children in the edit recipients box, who
can then be selected by ticking.

When I click merge to new document or merge to printer on the toolbar I then
end up with a list of lots of children on the database, but not those
specified.  Going back to edit recipients list to check the filter I find an
additional an additional line between <<Closed>>… and “and <<Group>>…” which
says “or <<closed>> is blank” before carrying on with the rest of the query.

Using different filters it appears that everytime I put in a line which says
“is blank” or “is not equal to” I get additional lines being put in.  
Sometimes it also adds additional sort criteria as well such as “sort by
postcode”.

……and sometimes it works as it should!

Sorry so long but hard to explain – and very desperate for a solution!
Thanks