Hi, thanks in advance for the help. I would like to create a query that indicates sums grouped by 3 separate fields. I currently understand how to group by values in one field, but I'm not sure how group by more than one field. Each of my "group by" fields are binary, so I want to create sums when the data in each respective field is "yes". (Basically sum when the criterian is "yes" to any of my three fields, and then group by each of these fields.) Here is how the existing table looks:
Group Var 1 Group Var 2 Group Var 3 Sum Var 1 Sum Var 2 Etc.
(binary) (binary) (binary)
I would like my query output to look like this
Sum Var 1 Sum Var 2 Sum Var 3 etc.
Group Var 1
Group Var 2
Group Var 3
Thanks for the help!
Coline
Group Var 1 Group Var 2 Group Var 3 Sum Var 1 Sum Var 2 Etc.
(binary) (binary) (binary)
I would like my query output to look like this
Sum Var 1 Sum Var 2 Sum Var 3 etc.
Group Var 1
Group Var 2
Group Var 3
Thanks for the help!
Coline