Richard, thanks for the video's. My issues spans or I think it spans several video's. I am using Access 2016 and when I built the UnAssignedServiceQ you had us put (is Null) in the ServicedBy section. When I ran the query it reveled nothing. As I tried to diagnoss before I bothered you I had replaced the (is Null) with a 0 and it worked. So I went back to the table to see what we set there and noticed it was defaulted to 0 and could not delete so deleted table and tried again and it set default to 0 again. Why is this a problem is because in video 16 you write (is Null) in the code and problem back so tried NZ to fix. please advise