AnsweredAssumed Answered

Case Statement Help Needed

Question asked by Tusquittee on Jul 24, 2013
Latest reply on Jul 26, 2013 by Tusquittee

Title

Case Statement Help Needed

Post

     HI again...Here's the case statement I'm working on but it doesn't evaluate properly.

      

     Case(
      
     Registrations::Session Name  =  ("ACOS"  and Status = "Enrolled"); LPR Table::ACOS Scholarship;
      
     Registrations::Session Name  =  ("ACOS"  and Status = "Withdrawn"); LPR Table::ACOS Scholarship;
      
     Registrations::Session Name   ≠   ("ACOS"  and Status = "Enrolled"); LPR Table::Basic Scholarship;
      
     Registrations::Session Name   ≠   ("ACOS"  and Status = "Withdrawn"); LPR Table::Basic Scholarship;
      
     "0" 
      
     It is giving everyone the Basic Scholarship, and no one gets the ACOS Scholarship.  I think the and statement isn't working the way I imagined it would.  Any suggestions, and thanks for all the wonderful filemaker help... I'm almost done with my project, and never would've made it without the forum.

Outcomes