Multiple Output Per Conditions

[Guest]

In an update query, can I somehow do the following:
If Condition 1 is met update a field in a table from null to "-1"
If Condition 2 is met update the field to "-0.5"
If Condition 3 is met update the field to " 0"

The conditions are
1) TimeCharged -1 + PrevBal > 0
2) TimeCharged -1 + PrevBal = -0.5
3) TimeCharged -1 + PrevBal < -0.5

 

[Guest]

The statement in the update to would be like
'IIf([time]=1,1,IIf([time]<1,-0.05,+0.05))'

 

[Guest]

Thank you for your response. It sent me in the right directions. Thx again

The statement in the update to would be like
'IIf([time]=1,1,IIf([time]<1,-0.05,+0.05))'

--
HTH
Martin J

In an update query, can I somehow do the following:
If Condition 1 is met update a field in a table from null to "-1"
If Condition 2 is met update the field to "-0.5"
If Condition 3 is met update the field to " 0"

The conditions are
1) TimeCharged -1 + PrevBal > 0
2) TimeCharged -1 + PrevBal = -0.5
3) TimeCharged -1 + PrevBal < -0.5