[AccessD] altered query

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




More information about the AccessD mailing list