My query is linked to a couple tables, one of which contains the fields Date,
Type, Hours. There are only four different  categories of "types."

In the query then created four additional columns. In these columns, I
wanted to total each "type" category seperately. I would want the query to
look like this:

Date     Type   Hours   TypeRTotal   TypeITotal    TypeBTotal
1/4          R         2              2        
5/2          I          5                                      5
3/24        B         9                                                      
      9
2/12        R         4              4

Now I can almost get this to work, except that then I set the criteria to
[Type]="IND", it does not include any rows where that condition isn't true.
Therefore, I set those criteria in all of the TypeTotal Columns, no rows
appear because no rows match all criteria, only one of them, at the most.

So, any ideas? Is there a better way to do this than set criteria? I can
provide more info if needed