Sorgu türünü Tablo Yapma sorgusu olarak değiştirmeyi denediniz mi?

Yeni bir buton ekleyip tıklandığı olayına

    Dim stDocName As String



    stDocName = "Adnan"

    DoCmd.OpenQuery stDocName, acNormal, acEdit

Mevcut Adnan isimli sorgunuzu da aşağıdakiyle güncellerseniz YeniTablo isminde tablonuz oluşacaktır.

SELECT T501_Devamsizlik.[sırano] AS Field0, T501_Devamsizlik.[tck] AS Field1, T501_Devamsizlik.[ay] AS Field2, T501_Devamsizlik.[a1] AS Field3, Null AS Field4, Null AS Field5, Null AS Field6, Null AS Field7, Null AS Field8, Null AS Field9, Null AS Field10, Null AS Field11, Null AS Field12, Null AS Field13, Null AS Field14, Null AS Field15, Null AS Field16, Null AS Field17, Null AS Field18, Null AS Field19, Null AS Field20, Null AS Field21, Null AS Field22, Null AS Field23, Null AS Field24, Null AS Field25, Null AS Field26, Null AS Field27, Null AS Field28, Null AS Field29, Null AS Field30, Null AS Field31, Null AS Field32, Null AS Field33 INTO YeniTablo

FROM T501_Devamsizlik;