You should be able to use the standard "Contains Text" Query, on it's own or use the results from it to populate the Report Record selection. So select Individual Summary, then on the Record selection use Add using Query and run the Contains Text query and enter the result you want. If you want to select additionally by letter of the Alphabet just copy the Contains text query to a new one and add a Exclude unless Surname starts with, set as a parameter and select the letter as you go. On 22 August 2011 18:39, Graham Anstey <ganstey@lodgegate-wood.org.uk> wrote: > What I'd really like to be able to do is to run an individual summary report > (or similar) for each person who has a particular word in any of their > records. I can't see how to do this using a query as it seems like I have to > add a condition for every record type. -- Jane. Jane Taubman | www.rjt.org.uk | www.taubman.org.uk |www.fhug.org.uk

> You should be able to use the standard "Contains Text" Query, on it's > own or use the results from it to populate the Report Record > selection. > > So select Individual Summary, then on the Record selection use Add > using Query and run the Contains Text query and enter the result you > want. > > If you want to select additionally by letter of the Alphabet just copy > the Contains text query to a new one and add a Exclude unless Surname > starts with, set as a parameter and select the letter as you go. Thanks Jane - Perfect! Graham No virus found in this outgoing message. Checked by AVG - www.avg.com Version: 9.0.901 / Virus Database: 271.1.1/3848 - Release Date: 08/22/11 07:35:00