Calculating Txtbox based on value of 2nd txtbox

[donsi]

On my report, I have two txtboxes which are not part of the query (control source are the expression which pulls record from other fields). Now I want to add txtbox2 based on the value of txtbox1 for all the records.

i tried below expression but it is asking for parameters since textboxes are not linked to query or not part of the query

=Sum(IIf([NetStatus]="Pending",[AccessTotalsAmount],0))

Please see below attached example of the report I would like to produce.

Please let me know how can this be achieved.

 

[Ranman256]

The EASIEST way is put it in the query.
Then just connect the textbox to the result.