Tablodaki isimleri degistirince bisürü yer karisiyor,onun icin tablo isimlerinin aciklamasini tasari kisminda aciklama bölümlerine yapmistim...
problemi halledebildim...ilginize tesekkür ederim....
---------------------------------------------------
SELECT Anwesenheit_yoklama.Sch_ID, Anwesenheit_yoklama.An_Datum, Anwesenheit_yoklama.Zustand,
Anwesenheit_yoklama.Notizen AS Anwesenheit_yoklama_Notizen,
"" AS Schulmaterial, "" AS Mitarbeit, "" AS HB_anfertigung, "" AS Verhalten_performans_Notizen
FROM Anwesenheit_yoklama
WHERE (((Anwesenheit_yoklama.Sch_ID)=[Forms]![ögrenci_detay]![Sch_ID]))
union
SELECT Verhalten_performans.Sch_ID, Verhalten_performans.Pr_Datum, "" AS Zustand,
Null AS Anwesenheit_yoklama_Notizen,
Verhalten_performans.Schulmaterial, Verhalten_performans.Mitarbeit, Verhalten_performans.HB_anfertigung,
Verhalten_performans.Notizen AS Verhalten_performans_Notizen
FROM Verhalten_performans
WHERE (((Verhalten_performans.Sch_ID)=[Forms]![ögrenci_detay]![Sch_ID]))
---------------------------