I have a query in Access (2007) and I want to build an 'If then else' statement. The code below is what I am currently using (without the proposed new statement) but here is the logic that I want it to do:
1) Before the code attached is used I want the statement to check to see if '[AttendanceCalc]![Session
' = 0.
2) if '[AttendanceCalc]![Session
' does = 0 then return 0 in the query results (currently it return '#error').
3) else do the calculation attached.
Can anyone help with this please?