Sorry - here is some sample data

EmpID CK# CKDate Amount

1 ...

the solution is the same as posted by Nate. I just added a date filter to both Select Statements and it worked.

I was able to make this work.

Many Thanks!!!!!!

Actually it would not make any difference to me, so long the empid, division, dept are unique.

I would also like to filter the records by certain date.

thanks

Thanks it works but the only problem is if I select records by only certain date, the percentages are off.

It seems to taking percentage of all records.

Thank you for your response. I would like to show a zero when the divide by zero error is encountered.

I know I can use the ISNull and ifnull but I...

Thanks for your feedback.

I want all the records from tblPRHISTEARNDetails reported, including Null values.

The strange thing is it is reporting the null values. So I tried...