Hello all.
I'm creating a view, and part of it.. one of the fields, i sum lets say
hours + line hours As TotalHours, itll find the 3 records, sum them,
and give me the correct amount of hours.. but I also have another field
that is totalhours / product made .. I need this to also show in the
view, but i first have to sum the total hours field. I tried doing
(SELECT Sum(hours+linehours) from table) / productmade but it gives me
the error about using an aggregate function in a group by or sum list?
Anyways, I'm not too great in SQL so if anyone has any ideas, id
greatly appreciate it. I can paste the code if it will help at all, but
its rather lengthy.
TIA