Enter find mode
Enter >= 18 in the age field
Enter London in the city field
Perform the find and you should find all contacts where the person's age is greater than or equal to 18 AND that live in London.
This can also be scripted
Sorry I mean I wanted it to be presented as a report so it can be printed.
Let’s say you want to find everyone who is named Chris OR is female. You want to find all the Female records, whether they’re named Chris or not, and all the Chris’, whether they’re Female or not.
First, enter the Find mode and enter “Chris” in the name field. Next, under the Requests menu, select “New Request” (or hit control/command + n). Now you have a second request. For that request, enter “Female” in the gender field. Now hit enter. You should find seven records. Four have a gender of Female. Four have the name “Chris”. One, Christina Ricci, has both.
Adding new requests is like telling FileMaker I want this OR that.
Again, thanks but - forgive me if I'm being dumb - it seems as if that's just finding records and viewing them on the screen. What I need is to create a report to print and show to superiors..
Create a new Layout in LIST form and on a single line, drag the fields you need to display for each record. Then do the find and the records from the found set will appear on the New List Layout. Then do Print.
Finding records is the first step to producing a report and that was the first part of the process you seemed to be having trouble with. Once you have a found set of the records you want, you can sort them and then design any number of different reports that display data from your found set of records.