3 Replies Latest reply: Apr 13, 2015 6:27 AM by Joanna Seldon RSS

    calculations with columns , but issue with null entries

    Joanna Seldon

      Hi

       

      I have two columns in a database

       

      Column one = Teaching_Session_Tutor        (This person is scheduled to teach the session)

      Column two = Teaching_Session_Tutor_Actual (This person actually teaches the session)

       

      the issue I have I want to count the sessions taught actual by tutor name, by month ect

       

      but problem I have is

       

      Teaching_Session_Tutor column is filled in (no problems there)

       

      but because they taught the session too ....some people have forgotten to enter the name in Teaching_Session_Tutor_Actual and it shows null

       

      is there a way of way of counting between these two columns, and finding the actual correct number of sessions taught by a tutor?

       

      Kind Regards

       

      Joeybird