AnsweredAssumed Answered

Conditional report

Question asked by MikeJ on Mar 5, 2010
Latest reply on Mar 5, 2010 by MikeJ


Conditional report


I have been testing Filemaker Pro 10 with a view to changing from Windows based Acess to an Apple OS using Filemaker Pro


I want to run a report, or even a simple listing, from a single table. There are 3 criteria for the report.


Field A contains a supplier ID number.

Field B contains simply a "Y" or "N"

Field C contains simply a "Y" or "N"


I want to run a report that refers to a specific number in field A and then a "N" for each of fields B & C as a list.


In Access it is a 30 second job using a query. I have been searching all over this website but cannot find a solution. Any ideas please?