if they are unrelated fields how did you get them to display accurately on the layout.
Sorry my mistake.
I have 2 related tables (Projected Costs and Tasks) displaying 2 different calculation fields.
At the moment they both give a accurate sum of the projected costs (Projected_Sum) and actual costs (Tasks_Sums). When I try to take them away
ie Projected_Sum - Tasks_Sums = value
I get the Projected_Sum - the 1st record in Tasks_Sums list
not what I want
My formula is
Table: Projected Costs
Options: Unstored, = Projected_Sum - Tasks::Tasks_Sums
"I get the Projected_Sum - the 1st record in Tasks_Sums list"
It sounds then like Projected_Sum has more than one related Tasks_Sums record? If so then you need to sum Tasks_Sums instead, something like:
Projected_Sum - Sum ( Tasks_Sums)
However, all this 'summing' suggests something isn't quite right in your structure. Your tables should be simple data tables and not named 'sum'. If you wish to discuss and consider whether your structure should be tweaked then I suggest you post again (in another thread) explaining your relationships and what the tables contain so that others can take a look at it.