Count problem

[1616]

Sorry to pester but could someone help me with the following problem

I have four fields complete 1 complete 2 complete 3 and criteria complete, each complete field can either be 'Yes' or 'No'

Hw can i make criteria complete= The number of complete fields that = Yes

eg

Complete 1= Yes

Complete 2= Yes

Complete 3= No

Therfore criteria complete would = 2

[1616]

please help me with this its very important, i would be very grateful for any help

[QuinTech]

Hi, 1616. Given your questions and the apparent urgency of answering them, i would suggest you immediately hire a Filemaker developer to help you. I don't mean to be rude, but your questions are quite basic, and free, internet-based, volunteer support is probably not your best option. Further, it is Sunday afternoon in America, where a lot of our members live, and the fact that you did not get an answer within 40 minutes does not constitute an emergency in our minds. To answer your question:

THE EASY WAY: Create three calc fields:

Complete1Flag = Case ( Complete 1="Yes" , 1 )

Complete2Flag = Case ( Complete 2="Yes" , 1 )

Complete3Flag = Case ( Complete 3="Yes" , 1 )

Also,

CriteriaComplete = Complete1Flag + Complete2Flag + Complete3Flag

This approach presents several problems which it would take a long time to explain. Thus, i present:

THE GOOD WAY: Hire a developer.

HTH,

Jerry

[1616]

Ok thank you very much for your help this is all basically for a college project i dont intend to use filemaker pro that much after this, therfore i feel it would be a bad idea to hire a developer