G
Guest
I want to display a percentage of attendance on a form, but I cannot think
how to generate the value.
I have a table tblMDTmemberattendance which has the fields
attendanceId Autonumber
TblMDTMemberID (Number) (PK)
TblMDTDateID (Number) (PK)
Attended (Number)
The attended field is 1 if Attended or 2 if not attended it is filled by a
combo attached to another table to give me flexibility instead of just yes/no.
How would I generate a percentage of attendance from this, I originally did
a query which counted the number of recoirds =1 and thought I would divide
this by total records for each attendee and multiply by 100, but cannot get a
total number of records count
any ideas
thanks
Phil
how to generate the value.
I have a table tblMDTmemberattendance which has the fields
attendanceId Autonumber
TblMDTMemberID (Number) (PK)
TblMDTDateID (Number) (PK)
Attended (Number)
The attended field is 1 if Attended or 2 if not attended it is filled by a
combo attached to another table to give me flexibility instead of just yes/no.
How would I generate a percentage of attendance from this, I originally did
a query which counted the number of recoirds =1 and thought I would divide
this by total records for each attendee and multiply by 100, but cannot get a
total number of records count
any ideas
thanks
Phil