Hi all,
I've started getting an overflow error on the following:
SELECT qrySessionsAttended.StudentID, qrySessionsAttended.TotalSessions, qrySessionsAttended.SessionsAttended, [SessionsAttended]/[TotalSessions] AS AttendancePercentage
FROM qrySessionsAttended;
I assume the error is being caused by [SessionsAttended] and [TotalSessions] occassionally = 0, but I'm not sure how to get around this. It is correct that the two fields may = 0 so how can I get Access to leave those records without trying to calculate 0/0?
:banghead:
I've started getting an overflow error on the following:
SELECT qrySessionsAttended.StudentID, qrySessionsAttended.TotalSessions, qrySessionsAttended.SessionsAttended, [SessionsAttended]/[TotalSessions] AS AttendancePercentage
FROM qrySessionsAttended;
I assume the error is being caused by [SessionsAttended] and [TotalSessions] occassionally = 0, but I'm not sure how to get around this. It is correct that the two fields may = 0 so how can I get Access to leave those records without trying to calculate 0/0?
:banghead: