Summing Totals

[DW]

Thats it , I'm at the end of my tether now.
I've attached a demo of my problem if some-one can help me out.

The 4 fields on the form to the left work ok, Summing each column correctly.

The 3 fields to the right is where I am struggling.

I need to do the following:-

Add New & R-R if UnitId = F
Add New & REP if UnitId = B

Relating to the current EstimateNo & Supp.

Thanks all for participating.

Dave

 

[Oldsoftboss]

Hope this is what youre trying to achive.

 

[DW]

Not quite what I was after.

On the main form you see 3 unbound texts.

Paint
Body
Fit

The paint text is straight forward as paint is always the total of Paint.

The other two texts are the problem.

Body needs to show the total of New+Rep if unitid=B

Fit needs to show the total of New+R-R if Unitid=F

You see replacing an item can be an operation of both.
Lets say we fit a roof, this is a body operation "B"

etc

Dave