Calculated Value

[paulS30berks]

I have a table that contains 2 columns:

1 = Deduction Reference Code
2 = The Value associated with each Code.

for example

Deduction Reference Value

999997 10000
666 6000

Code 999997 duplicates the value within code 666 so I wish to set up a caluclated value to say:

If deduction reference = 999997 then the value of 999997 minus the value of deduction reference 666.

I have tried several statements but none of which seem to work.

Can anyone help?

Thanks

 

[Robert88]

Hi paulS30berks,

What type of fields do you have these values stored in, as this is going to make a difference to how these are calculated?

Robert88