AnsweredAssumed Answered

Calculation Help - Calculation (Case Function)

Question asked by lovelandj on Mar 23, 2016
Latest reply on Mar 24, 2016 by fitch

Hello,

 

I need to create a calculated Pass Fail Field based on a passing grade located in another Table by course. ( I am open to a better way if there is one)  I am not sure how to create the case function to put Pass or Fail in the field based on data from another Table.

 

Example:  Student 1 passes Performance test based on the score in Table two.

                  Student 1 Passes Written test based on the score in Table Two.

                    Overall Passed (because they passed both Tests)

 

                  Student 2 Failed Performance test based on score in Table Two.

                   Student 2 Passed Written test based on score in Table Two.

                         Overall Failed (based on failing one part of the test.)

 

                  Student 3 Passed Performance test based on score in Table Two.

                   Student 3 Failed Written test based on score in Table Two.

                         Overall Failed (based on failing one part of the test.)

 

 

 

Table One

 

I have fields named:

Last Name

First Name

Test Name

Test ID

Performance Score

Written Score

Pass or Fail Preformance

Pass or Fail Written

OverAll Pass or Fail

 

 

Table Two  ( Note -  Test Name and Test ID are the same in table one)

 

I have fields named:

Teat Name

Test ID

Performance Score

Written Score

 

Thank You in advance for the help.  

Jeremy

Outcomes