The query looks OK now. Are you sure you have JobHeads table?
Also from what you have posted it looked like you wanted to do a cross-tab.
>Thanks, Sergey. Yes, I'd just figured that and tried it after posting, as Agnes stated too. In that order I get "variable Jobheads not found".
>
>Oops, belay that. I'd forgotten to take the AND clause with the WITH. I'm just checking my results now.
>
>
If it's not broken, fix it until it is.
My Blog