aşağıdaki kodu sorgu penceresine yazıp dener misiniz?
SELECT Replace([metin1],'(tarih)',[metin11]) AS metin_1, Replace([metin2],'(tarih)',[metin22]) AS metin_2, Replace([metin3],'(tarih)',[metin33]) AS metin_3, Replace([metin4],'(tarih)',[metin44]) AS metin_4, Replace([metin5],'(tarih)',[metin55]) AS metin_5, Replace([metin6],'(tarih)',[metin66]) AS metin_6, Replace([metin7],'(tarih)',[metin77]) AS metin_7, Replace([metin8],'(tarih)',[metin88]) AS metin_8, Replace([metin9],'(tarih)',[metin99]) AS metin_9, Replace([metin10],'(tarih)',[metin100]) AS metin_10, Tablo1.metin11, Tablo1.metin22, Tablo1.metin33, Tablo1.metin44, Tablo1.metin55, Tablo1.metin66, Tablo1.metin77, Tablo1.metin88, Tablo1.metin99, Tablo1.metin100
FROM Tablo1;