Search results

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

Thanks for all your help

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