Last post Mar 28, 2016 09:27 AM by eThunderstorm
None
0 Points
1 Post
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?
Member
571 Points
117 Posts
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;
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?
Member
571 Points
117 Posts
Re: formula help
Mar 28, 2016 09:27 AM|eThunderstorm|LINK
SQL query: