Datenauswertung mit SQL-Befehl?

[omata]

So ein neuer Versuch...

SQL-Code:

SELECT MONTH(a.f_date) AS monat, YEAR(a.f_date) AS jahr, a.f_name, 
       SUM(IIf(b.f_content = 'S', 1, 0)) AS anzahl
FROM tbl_daten_v2 a
LEFT JOIN tbl_daten_v2 b
  ON (    a.f_date = b.f_date + 1
      AND a.f_name = b.f_name
      AND b.f_content IN ('S', 'F')
      AND a.f_content <> b.f_content)
GROUP BY YEAR(a.f_date), MONTH(a.f_date), a.f_name
ORDER BY YEAR(a.f_date), MONTH(a.f_date), a.f_name

Gruss
Thorsten