cool thx for your help, i am going to try something else but your suggestion did help

PS THIS IS NOT HOMEWORK

The code i wrote to accomplish this is

Select Insurer,location, Claim_number, datediff(day, start_day, end_day) / count(claim_number). count (claim_number) may noy work because,...

PS its not home works

If he has different claims with different claim number

That would be a different line item.

so 555 would have lets say 12days date diff divide by 3 claims

if he has a...