Going back to original Query posted in the question, here is the issue. Notice my sick hours aren't tallying up because I hardcoded ONE date. I want to replace...

thank you guys, I did make progress based on your suggestions but I removed the aliases names from the date. Here is the updated sql query. Now i"m getting...

Wayne, I do appreciate your constant assistance.

Unfortunately it is still giving me that error even with P. Also I do need to iterate thought the dates from the pay...

Yes that is the idea but its giving me syntax error "The multi-part "Pr.Date" could not be bound."

Thank you!

works great..thanks!

Thank you so much for taking out the time. Everything works perfectly!

Thanks again!

...

Where (e.status='A' or pr.Hours > 0) and e.pay_type=1

...[/quote]

I came across another snag. 🙁 There is also another column "Validated hour" which is just a sum of hours (Pay...

Excellent.

One final Question. The Employee table also has status. Active or Terminated. I want to...

ScottPletcher (3/16/2015)

---

I wasn't sure which table "valid_payroll" is in, so I guessed "Employee". If it's not, adjust the code accordingly. Btw, always use a table alias on every...

This looks really good. Much simpler. Question is how do I show the employees at the bottom of the list whose hours are 0. I want to sort by Name...

MADAdmin. Thanks for your reply

That didn't work for me. I'm getting same result set after left joining. I'm not getting the employees from the other table that don't exist in...

Excellent! Thank you so much!