Date Relationship Problem

  Hello,   Despite reading a lot of material about this issue I am not able to achive the soluntion I require. I basically have 2 key tables.  Sales information that include date and salesr...