By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,220 Members | 1,044 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,220 IT Pros & Developers. It's quick & easy.

sum as type ....

P: 10









Thanks a lot
Farid Sukkar
Oct 15 '06 #1
Share this Question
Share on Google+
3 Replies


MMcCarthy
Expert Mod 10K+
P: 14,534
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)
Oct 15 '06 #2

P: 10
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
Oct 17 '06 #3

MMcCarthy
Expert Mod 10K+
P: 14,534
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![subformfootertextboxname]


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
Oct 17 '06 #4

Post your reply

Sign in to post your reply or Sign up for a free account.