Multiple Output Per Conditions

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Thank you for your response. It sent me in the right directions. Thx again

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

--
HTH
Martin J


neenmarie said:
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
Click to expand...
Click to expand...
 
Back
Top