As it happens I managed to get the below to do what I wanted (after more net scouring and SQL nudging) but having tested yours just now I can confirm it also does indeed work. Diff code but same results.
SELECT [Data-Billing].[Employee Number] AS [Emp No], Count([Data-Billing].[Employee Cost...
jzwp22 - thanks for getting involved however we've lost the distinct factor in your new code. For e.g.
SELECT Count(*) AS NumberofCCs
FROM (SELECT DISTINCT [Employee Cost centre] FROM [Data-Billing]) AS [Unique CCs];
This works and it gives me 88 distinct cost centres. Your code doesn't have...
I'm sure this is so simple for most access heads but I haven't really graduated from GUI to SQL yet and scouring the net hasn't helped (so no links to clever articles clearly above my head as I've probably seen them already). I need code to count distinct values per another field from the same...