"What do you see if you order the results by Vehicle.modelId? Do you get multiple rows per model? That's what I'm looking for."

Yes when I order them by Vehicle.modelId I get multiple rows per model, these are models that have had tyres changed etc, I need the total models column to give me the total amount of those models in the fleet, irrespective of anything

RepairSheetNrunitnrgroupidbrandIdmodelIdversionType_Fleetclose_dateTotalModels

500007651EDMNPEUGEOT207 S 1.48VOF 2012-03-06 00:00:00.00047