A03: Can't edit Query results

[chriswies]

SELECT idAuswertung, fiPrüffeld, fiAuswertungMaster, fiAuswertungTyp, AuswertungName, AuswertungSort, AuswertungActive, (SELECT COUNT ([idDiagramm]) FROM tkey_Diagramm WHERE fiAuswertung = [idAuswertung] ) AS AnzDiagramm
FROM tkey_Auswertung;

Why can I not edit the results when I use the Subquery above?
Without the Subquery all works fine.
Christoph

 

[chriswies]

DCOUNT in the query instead of the SELECT-Statement was the solution
Christoph