Calculations using if statement

[gravedigger]

This is what I have

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?

[Allan Murphy]

In a field of your column in your query add my_result:iif([liftingdevicetotal] = 0,([preusetotal] + [traveltotal] + [deposittotal] + [stackingtotal] + [parkingtotal]) / 100 * 1,
([preusetotal] + [traveltotal] + [deposittotal] + [stackingtotal] + [parkingtotal] + [liftingdevicetotal]) / 105 * 1)

Change my_result to a suitable otherwise the query will add Expr1: to the field.

[gravedigger]

Thank you very much!