1 Reply Latest reply on Oct 27, 2010 9:05 AM by philmodjunk

    Please help very stuck on finds?

    JessOttman

      Title

      Please help very stuck on finds?

      Post

      Please help very stuck on finds?

      hi

      i have a weekly call plan or log.eg for a sales person.who they need to  call to etc.there are 25 individual fields for comapany,date, class,  appointment etc but im just looking at company as its most important for  now.

      Iv imported data to a different table eg company names and have the  25 company fields(independently) showing you the company as you  type.(like google)The mon - fri is really just a template it doesnt  affect the fields. (one week plan = one record.)*


      Now say for example there are 35 records of this call plan. There is a  number of fields across these records with companies entered. If  somebody was looking to see how many times 'sales person A' went to  helix betweeen the dates 20/02/2009-20/08/2009.

      Is there a way to get all those entries of companies and dates and  show them on a report. So all i see is the company i typed in and the  dates 'sales person A' went there.

      I hope this makes sense any help is hugely appreciated been trying to figure it out for weeks!

      many thanks

      the.JPG