>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.
>>
>>

Thanks Naomi

The Jobheads problem was my placement of the where clause, as replied to Sergey and Agnes.

Maybe it does need a cross-tab but I've never done them in SQL and I thought I'd see how I get on here first. I'm getting resu8lts now but each sum is multiplied by 11 for some reasons (there are 12 records in my test set for teh given JobID).

Ah, there are 11records with an inv. no. in JobAct for that jobID, ie the ones I'm interested in.