remove the group by statement.
since you want to have the end result filter by both the data and the branch number you are going to have to show the duplicate dates.
The way this is working is that the first list passes the branch number.
in the second list we are using the branch number concatenated with the date to filter the third list.
values for the second list will look like:
30512-30-3010
this is branch number: 305 date: 12-30-2010