4 Replies Latest reply on Sep 25, 2013 10:36 AM by dankweb

    Summary Data

    dankweb

      Title

      Summary Data

      Post

           I have a member database with 100 records, where each member gets 4 types of clothing (shirt, jacket, etc...), and each clothing has a size (small, medium, etc...) which is particular to that member.

           What is the most efficient way to have an overall count of the total number of each item for each size.

           For example, if there were 15 people that had shirts of size small, 25 people had shirts of size medium, etc...

           Thanks 

        • 1. Re: Summary Data
          philmodjunk

               Set up a table related to members with one record for each item of clothing issued to that member. Create a summary report based on this related table. You can use sorting to group the records by type and size and a summary field placed in a sub summary layout part can provide the count for each such group of records.

          • 2. Re: Summary Data
            dankweb

                 Thanks...for further clarity, I want the layout something like below, but in the standard report, I am not seeing how to do this.

                                           

                                        Sizes

                 Items |   Small    Large

                 Shirt           15         23          

                 Pants        12         9

                 Thanks

                  

            • 3. Re: Summary Data
              philmodjunk

                   What I am suggesting, (You did ask "What is the most efficient way...") would look like this:

                   Shirts
                       Small   15
                       Large   23

                   Pants
                       Small    12
                       Large    9

                   Getting this data into two or more columns as shown will be more complex to set up.

              • 4. Re: Summary Data
                dankweb

                     Got it and that will work. I see where I was messed up in how I set up the layout.

                      

                     Thanks