07-12-2020, 22:18
sorunu yardım ile şu şekilde hallettim.
Visual Basic
- SELECT TB_ZİMMET.SİCİL, TB_ZİMMET.[AD SOYAD], TB_ZİMMET.MALZEME, TB_ZİMMET.[MALZEME ADI], TB_ZİMMET.TARİH,
- DateDiff("d",[TARİH],Now())\30 & " / " & DateDiff("d",[TARİH],Now()) Mod 30 AS [Ay / Gün]
- FROM TB_ZİMMET
- ORDER BY TB_ZİMMET.TARİH DESC;
