AnsweredAssumed Answered

Calculating Total of Values from Related Table

Question asked by ShaikhAtta on Jul 28, 2013
Latest reply on Jul 29, 2013 by philmodjunk

Title

Calculating Total of Values from Related Table

Post

     Hello I have 2 tables as below

         
  •           Table1           
                     
    •                     WP_ID
    •                
    •                     Month
    •                
    •                     Year
    •           
         
  •      
  •           Table2           
                     
    •                     WP_ID
    •                
    •                      Men
    •                
    •                     Women
    •                
    •                     Girls
    •                
    •                     Boys
    •           
         

      

     The relation is made as Table1 >> Table2 where the WP_ID is an auto generated serial which is linked in relation to each other

      

     Now as Table1 is the Main Head table and Table2 is the sub table where all the records are being entered. I want a calculation to be generated where in Table1 I can count the total number of Men, Women, Boys, Girls entered in a month.

      

     I am abit confused but I know someone is out there to help me out in this regard, Thanks in advance. 

      

Outcomes