Thanks, that works fine. But now i need to to do it by also Client_Reference_Number. So i have a list of all dates with all totals for one and only one client. When i try i don't get the details for the null days. I just get the dates with data. Any ideas?