Formula Help

[mjm697]

I am working on an incentive database. In this database,
I have three table’s name [Transaction Errors], [Potential Payout] and
[Actual Incentive Calculation]. If [Transaction Errors] is greater than 6
error’s then [Actual Incentive Calculation] will be $0.0, but if [Transaction
Errors] is less than 6 errors then [Actual Incentive Calculation] we be
whatever amount is in [Potential Payout].

Can this be done? I’m really new at this and I’m trying to learn as I go so
please let me know if there’s any other information you need from me to
figure this out. Thanks so much.

 

[pietlinden]

I am working on an incentive database. In this database,
I have three table’s name [Transaction Errors], [Potential Payout] and
[Actual Incentive Calculation]. If [Transaction Errors] is greater than 6
error’s then [Actual Incentive Calculation] will be $0.0, but if [Transaction
Errors] is less than 6 errors then [Actual Incentive Calculation] we be
whatever amount is in [Potential Payout].

Can this be done? I’m really new at this and I’m trying to learn as Igo so
please let me know if there’s any other information you need from me to
figure this out. Thanks so much.

use a query.
IIF(DCount("[Transaction Errors]", "[Some Field]", "[EmployeeID]=" &
12)>6,0,[Potential Payout])

 

[John W. Vinson]

I am working on an incentive database. In this database,
I have three table’s name [Transaction Errors], [Potential Payout] and
[Actual Incentive Calculation]. If [Transaction Errors] is greater than 6
error’s then [Actual Incentive Calculation] will be $0.0, but if [Transaction
Errors] is less than 6 errors then [Actual Incentive Calculation] we be
whatever amount is in [Potential Payout].

Can this be done? I’m really new at this and I’m trying to learn as I go so
please let me know if there’s any other information you need from me to
figure this out. Thanks so much.

You say you have three *TABLES* with these names. This isn't making sense; a
field in a table can have a value, but a table does not have a numeric value.

What is the structure of [Transaction errors]? Are you trying to count the
total number of records in the entire table [Transaction errors], or the
number of records for some particular criterion, or what?

If you're trying to store a calculated value then consider:
Storing derived data such as this in your table accomplishes
three things: it wastes disk space; it wastes time (almost
any calculation will be MUCH faster than a disk fetch); and
most importantly, it risks data corruption. If one of the
underlying fields is subsequently edited, you will have data
in your table WHICH IS WRONG, and no automatic way to detect
that fact.

Just redo the calculation whenever you need it.