Lynn,

The code you provided was very close to what I'm looking for. But I think you're right, I will have to do a select into a temp table to accomplish...

This is really close to what I'm looking for and I think it will get me going in the right direction without having to use a union. I told you...

What I'm after here is the following.

List of employee total pay hours for last week

How much of that was zvaca, zhol, zawar, etc.

There are three tables that hold the...