hi please help me here i want to get the average of the of the entry
ex.
in ym database
i have
i want to get the result per status countCode:ID Name Status NoWorkingdays month Time 1 a Present 20 1 AM 2 ab Present 20 1 AM 3 abc Present 20 1 AM 4 abcd Absent 20 1 AM 5 abcde Leave 20 1 AM 1 a Present 20 1 PM 5 abcde Leave 20 1 PM
this is done in querry of access
Please help..Code:tabale Records Status StatusCount Frequency(Formula is:StatusCount/noworkingdays) Percentage (what statusCount / totalrecord Present 3 0.15 (3/20) Absent 1 0.05 (1/20) Leave 1 0.05 (1/20)




Reply With Quote