Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
if(isnull ([Column two]),[Column one],[Column two]) as [Colum Three]
if(isnull ([Column two]),[Column one],[Column two]) as [Colum Three]
you can use [Column three] to count the sessions based on actual tutor
worked!!!
this work really well for a number of scenarios
thank you xx
Kind Regards
Joeybird