pedro at plex.nl
pedro at plex.nl
Fri Nov 11 13:09:45 CST 2011
Hello Group, why does access 2003 mutates a query from: SELECT NaamUitvoerder, Subagendanaam, COUNT(Patientnummer) AS UniekePatienten FROM (SELECT DISTINCT NaamUitvoerder, Subagendanaam, Patientnummer FROM Data2) Unieke_Pat GROUP BY NaamUitvoerder, Subagendanaam ORDER BY NaamUitvoerder, Subagendanaam; To SELECT NaamUitvoerder, Subagendanaam, COUNT(Patientnummer) AS UniekePatienten FROM [SELECT DISTINCT NaamUitvoerder, Subagendanaam, Patientnummer FROM Data2]. AS Unieke_Pat GROUP BY NaamUitvoerder, Subagendanaam ORDER BY NaamUitvoerder, Subagendanaam; When opening the query in designer mode. Pedro