formula help[Answered] RSS

• • Reply
  amberlynm

  None

  0 Points

  1 Post

  formula help

  Mar 24, 2016 05:58 PM|amberlynm|LINK

  Hello. I am needing some help combining the following:

  RW1 Rig Welder 47 
  RW1 Rig Welder 60 
  RW1 Rig Welder 11 

  I need it to combine same class and description and sum the hours.

  RW1 Rig Welder 118

  Is this possible?

• • Reply
  eThunderstor...

  Member

  571 Points

  117 Posts

  Re: formula help

  Mar 28, 2016 09:27 AM|eThunderstorm|LINK

  SQL query:

  SELECT id, description, SUM(hours)
  FROM your_table_name
  WHERE id = 'RW1'
  GROUP BY id;