Can I use the value function to convert that to value. e.g. value(right(itemcode,2)). In that case also how can it convert the P5 strings ?

Prabin Misra

Sorry for being late in replying to this Solution. Thanks Antares686 and GRN for delving into the matter meticulously.

I think slno won't work out becoz the itemcodes are not in...

Thanks for the solution. but I could not understand why u have "SumOfHoursCharged" in that query. I might be wrong in explaining the problem. I will give u a sample...

Thanks. It is not 70% of the records. if the total value of sale is 100, I require the no of items in descenging order of sale(total value) whose...