Reflect changes based on field choice

[myxmaster]

On my form I have a field called amount and a field called Check
status. The amount signifies a check amount and status signifies
pending, returned or cleared. Is it possible that when cleared is
selected a calculation will automatically reflect the change .Example:

Available Balance $5000

Check Amount Status
$3000 Pending

Balance reflects $2000 available

Check Amount Status
$3000 Cleared

Balnce reflects $5000

I know in excel I would achieve this with an IF function however I am
somewhat lost in Access

TIA

 

[Allen Browne]

Use an expression in a query to get the result of the calcuation.

The basic idea is described here:
Calculated Fields
at:
http://allenbrowne.com/casu-14.html

You probably need an IIf() expression.