[AccessD] altered query

Gustav Brock Gustav at cactus.dk
Fri Nov 11 10:47:53 CST 2011


Hi Pedro

Don't know why except that it is good ol' JET SQL syntax.

/gustav


>>> pedro at plex.nl 11-11-2011 13:09 >>>
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