finding month or weekly sales from date ranges using multiply fields
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 ?