Ok, thank you for the information Drew.

Brilliant, thank you very much for you help.

Hmmm, it doesn't seem to like me using the square brackets when I'm doing a join. It says invalid column name

SELECT
[S.SERVICE],[V.VEHICLE],
count(*) as Quantity,

Oh, i've just realised all I have to do is put the '[' brackets around the vehicle as well as the service. Brilliant.

Thank you very much

Hello,

Thank you for you response. 

It's close but the issue is it counts the job with ND16 service and NEXTDAY vehicle in with the rest of the...

It's ok, I've found the solution. There must have been something wrong with the other users ini file because I copied and pasted the log in section from first user...

I’ve been thinking about this over the weekend. Even if it is an insert I’m going to have to see if there is a record already in the aggregate table...