2 Replies Latest reply on May 22, 2006 8:37 PM by MikerRoo

    Looping over multiple rows of data to output one row

    ldrenning Level 1
      My query is giving me the appropriate data, but I need to only have one row per 'MANAGER' in my output - not one for each 'JOB'. Now the output looks like this:

      manager 1 ... period 1 $ .... period 2 $ .... period 3 $
      manager 1... period 1 $ .... period 2 $ .... period 3 $
      manager 1... period 1 $ .... period 2 $ .... period 3 $
      manager 1... period 1 $ .... period 2 $ .... period 3 $

      manager 2... period 1 $ .... period 2 $ .... period 3 $
      manager 2... period 1 $ .... period 2 $ .... period 3 $
      manager 2... period 1 $ .... period 2 $ .... period 3 $
      manager 2... period 1 $ .... period 2 $ .... period 3 $

      It needs to be:

      Manager 1 ... total period 1 $ .... total period 2 $ ....
      Manager 2 ... total period 1 $ .... total period 2 $ ....

      Any help would be wonderful. I am really new at something this complex. Thanks!!!