Now when I create a report with a filter on Date of e.g Nov. It will pick up the October dates that have been entered in the subform also as i think it treated the entry as one. 

Now in the last entry as you can see I only want the $300 amount of Nov to show and not the $300 of October. 

My search criteria is very simple for the report . I have specified the dates to be of Nov. 

Can anyone guide as to what I can do here.