discusmania
IS-IT--Management
Hi guys... can u help me?
1. In my table named action, i've fields called date_enter, date_close and category (and other fields).
2.I used the :
dateDiff("d",results("date_enter"
,results("date_close")
to calculate number of days between date_enter and date close
3.Then i check date_close of that record fall on what week of the year. and the record belong to which category.i.e downtime, quality, etc.
4.the program should accumulate all the records with same workweek and category till end of records.
5.The accumulated value will then be divided by the number of records with the same workweek and category, to get the average time.
who can help me to do this?
Thanks so much in advance.
Ron
1. In my table named action, i've fields called date_enter, date_close and category (and other fields).
2.I used the :
dateDiff("d",results("date_enter"
,results("date_close")to calculate number of days between date_enter and date close
3.Then i check date_close of that record fall on what week of the year. and the record belong to which category.i.e downtime, quality, etc.
4.the program should accumulate all the records with same workweek and category till end of records.
5.The accumulated value will then be divided by the number of records with the same workweek and category, to get the average time.
who can help me to do this?
Thanks so much in advance.
Ron
