3 Replies Latest reply on May 15, 2013 2:42 PM by philmodjunk

    finding month or weekly sales from date ranges using multiply fields

    thomaskenneson

      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