for x=1 to 31
nsAY=nsAY+ DCount("Kimlik";"TblNobet";"G" & x & " = 'N' AND [donem]=#" & Format([Forms]![FrmNobet]![Dtdonem];"mm/dd/yyyy") & "#")
next x
yadaDCount("Kimlik";"TblNobet";"(G1 = 'N' or G2='N' or G3='N'.......... )AND [donem]=#" & Format([Forms]![FrmNobet]![Dtdonem];"mm/dd/yyyy") & "#")
denemedim sadece tahmini