AnsweredAssumed Answered

finding month or weekly sales from date ranges using multiply fields

Question asked by thomaskenneson on May 14, 2013
Latest reply on May 15, 2013 by philmodjunk

Title

finding month or weekly sales from date ranges using multiply fields

Post

     Im trying to find a script or calculation for my database problem. im using fm12. I would like to find sales between a date range. I have a small amount of records, but, each record carries all the info per student, ie lots of fileds in a colunm (see screen shot)

     I have an ID for each record and I only use one table. My records consists of 40 dates (one per lesson) arranged in a columns and like wise with fees paid and time and balance cloumns.

     I constructed the data base this way as to see at a glace each students previous lessons and payments,per record. I have done lots of calculations to sum fields together and it works really well, but I cant seem to work this out.

     Can anyone give me help ?

      

Screen_Shot_2013-05-14_at_23.21.20.png

Outcomes