sum as type ....

[loissuha]

Thanks a lot
Farid Sukkar

[MMcCarthy]

You don't say if this is a form or report.

Either way, create a form/report footer

Put in the two controls

Control 1 (Total Input) - Make the control source equal to the following
Sum(IIf([Type]="Input",[No3],0)

Control 2 (Total Output) - Make the control source equal to the following
Sum(IIf([Type]="Output",[No3],0)

[loissuha]

thank you for help me ...
i try the code you give to me ... and i have a problem ... that the sum of result of all
input , and of all output ..

i upload to you the program picture , and i upload to you my test program ...



Download program
please help me .. thank you very much to you .
Best Regards
Farid Sukkar

[MMcCarthy]

Put the form footer on the subform as previously described.

Now put a textbox control on the main form and set to

=Me![SubformName].Form![subformfooterte xtboxname]

thank you for help me ...
i try the code you give to me ... and i have a problem ... that the sum of result of all
input , and of all output ..

i upload to you the program picture , and i upload to you my test program ...



Download program
please help me .. thank you very much to you .
Best Regards
Farid Sukkar