I lost the code due to db refresh. Now I have to start all over again and worst part is I don't remember how I fixed this. Dang. Oh yeh,...

Thanks all. I managed to use left join with the "Master" table. I got it to work.

Once again thanks for the help.