Multiple Output Per Conditions

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

neenmarie - 18 May 2005 18:28 GMT

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

Reply to this Message

Martin J - 18 May 2005 20:21 GMT

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

Signature

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"
[quoted text clipped - 5 lines]
> 2) TimeCharged -1 + PrevBal = -0.5
> 3) TimeCharged -1 + PrevBal < -0.5

Reply to this Message

neenmarie - 19 May 2005 03:12 GMT

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))'
[quoted text clipped - 8 lines]
> > 2) TimeCharged -1 + PrevBal = -0.5
> > 3) TimeCharged -1 + PrevBal < -0.5

Reply to this Message