Calculation fields sum of Fields

[Vitality]

Hi.

I have attached an example, please help me.

There are two table with ralationships: "tblCargo" and "tblPackages". They are in Continous Form "FrmCargo", here I can check records, which of them I want to calculate in form "FrmCalculte". I this Form I need to calculate values of field "Weight". What can I do this?

Thank You for help in advance.

 

[flixx]

To Vitality:
I have modified your database by adding in 2 queries
and modified the continous form, so yo can have Total
at the bottom. On the calculated form i used a copy of
the first query I built and if you look at the design you
will see where I placed a parameter to only to allow
selected records to be selected for the query. I believe
this is what you was after, if not let me know.
Hope this helps, if you can contact me Thecpc - Live Chat ,its located upper right corner. Flixx.
FYI: Attachment database is called example1.zip

 

[Vitality]

Thank You! Its working good!!