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

    calculations with columns , but issue with null entries

    Joanna Seldon



      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