Hi guys, I was given this to use but its not working in Access and my SQL knowledge is just at the start of my journey im afraid.
SELECT systemno,
COUNT(DISTINCT postcode) AS Total
FROM dbo.InterData
WHERE disdate >='20150301' And disdate <='20150331'
GROUP BY systemno
HAVING (COUNT(DISTINCT postcode)) >1
SELECT systemno,
COUNT(DISTINCT postcode) AS Total
FROM dbo.InterData
WHERE disdate >='20150301' And disdate <='20150331'
GROUP BY systemno
HAVING (COUNT(DISTINCT postcode)) >1
SQL error
