Sorgu isimli sorgunun Sql kodunu aşağıdaki ile değiştirip deneyiniz.

SELECT First([KisiID] & [cesit] & [sebebi] & [onay] & [durum] & [Kisi_AdSoyad]) AS veri, First(Sorgu1.Tarih) AS İlkTarih, First(Sorgu1.Saat) AS İlkSaat, Sorgu1.KisiID, Sorgu1.Kisi_AdSoyad, First(Sorgu1.Sebebi) AS İlkSebebi, First(Sorgu1.Cesit) AS İlkCesit, First(Sorgu1.Onay) AS İlkOnay, First(Sorgu1.durum) AS İlkdurum, First(Sorgu1.Foto1) AS İlkFoto1, First(Sorgu1.Foto2) AS İlkFoto2, First(Sorgu1.Foto3) AS İlkFoto3, First(Sorgu1.Foto4) AS İlkFoto4, First(Sorgu1.Foto5) AS İlkFoto5, First(Sorgu1.Foto6) AS İlkFoto6, First(Sorgu1.Foto7) AS İlkFoto7, First(Sorgu1.Foto8) AS İlkFoto8, First(Sorgu1.Foto9) AS İlkFoto9, First(Sorgu1.Foto10) AS İlkFoto10



FROM Sorgu1

GROUP BY Sorgu1.KisiID, Sorgu1.Kisi_AdSoyad;