This is what I have
Code:
If Me.liftingdevicetotal = 0 Then
Me.Grade = ([preusetotal] + [traveltotal] + [deposittotal] + [stackingtotal] + [parkingtotal]) / 100 * 1
Else
Me.Grade = ([preusetotal] + [traveltotal] + [deposittotal] + [stackingtotal] + [parkingtotal] + [liftingdevicetotal]) / 105 * 1
End If
is there away this could be done in a query?