[lmikle]

Делай подзапросами. Носколько помню, ОЛАПа для аксеса нету.
Что то типа:

Код:

SELECT DISTINCT T1.Sadik_Name,
  (SELECT Count(*) FROM MyTable D1 WHERE D1.Sadik_Name = T1.Sadik_Name AND Age >= 0 AND Age < 2) AS Age_0_2,
  (SELECT Count(*) FROM MyTable D2 WHERE D2.Sadik_Name = T1.Sadik_Name AND Age >= 2 AND Age < 3) AS Age_2_3,
  ...

FROM MyTable T1