calculations with columns , but issue with null entries

[joeybird]

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

[jpenuliar · Accepted solution]

if(isnull ([Column two]),[Column one],[Column two]) as [Colum Three]

[jpenuliar]

you can use [Column three] to count the sessions based on actual tutor

[joeybird]

worked!!!

this work really well for a number of scenarios

thank you xx

Kind Regards

Joeybird