thanks - i used the ISNULL function and it worked perfectly

thanks - this really pointed me in the right direction - i ended up using the case statement so that i could sum the amount owed by debtors based on...

this worked well! i had to put the * on the lEft side of the = sign though cos i found out the (+) where iT was in the query...