charkerr6111
asked on
Coding for summary based on a calculated field
I am retrieving data out of a labor billing table. I have fields available for hours, billing extension, and name. The only missing item is billing rate, which I can get by creating a field using billing extension / hours. I am trying to find the best way to do a single line for each employee for each rate, which is that calculated field. The data would look something like this:
Bill 2 (hours) 100.00(billing extension) 50.00 (Rate)
Bill 1 (hours) 75.00(billing extension) 75.00 (Rate)
Steve .5(hours) 30.00 (billing extension) 60.00 (Rate)
There could be many detail lines in the data that make up the single summary lines. Not sure what the best way to group these lines together - would be very easy if the billing rate was an actual field, but it is not. Simplified query attached.
Bill 2 (hours) 100.00(billing extension) 50.00 (Rate)
Bill 1 (hours) 75.00(billing extension) 75.00 (Rate)
Steve .5(hours) 30.00 (billing extension) 60.00 (Rate)
There could be many detail lines in the data that make up the single summary lines. Not sure what the best way to group these lines together - would be very easy if the billing rate was an actual field, but it is not. Simplified query attached.
select name, (reghrs) as hours, billext, (billext/reghrs) as billrate from LD
group by Name, RegHrs, BillExt
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER