ACCESS - Calulations - Please help

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

Guest

I am trying to create this formular but can't figure it out.

Buget Cost - Actual Cost
If the actual cost is hiring than the budget for access to put in in the
overbudget field and if the actual cost is lower than the budget cost for
access to put in the underbudget field. Also fill in the box with a chosen
color. Does anyone know what I need to do.
 
In the "overbudget field" on your form, put the following:

=Iif([ActualCost]>[BudgetCost],[ActualCost]-[BudgetCost],)

In the underbudget field, put:
=Iif([BudgetCost]>[ActualCost],[BudgetCost]-[ActualCost],)

As far as the color, just set the format to whatever color you want.

Rick B
 
Back
Top