:-)
hi!
can somebody help me, pls;
i have an acces database, and a querry "Q1" that counts some records, depending on the value of one combo on the form. This is sql view of the querry:
"SELECT Count(tblZARAZNABOLEST.idZarazna) AS CountOfidZarazna
FROM tblGRADOPCINA INNER JOIN (tblNASELJE INNER JOIN tblZARAZNABOLEST ON tblNASELJE.idNaselje = tblZARAZNABOLEST.idNaselje) ON tblGRADOPCINA.idGradOpcina = tblNASELJE.idGradOpcina
GROUP BY tblGRADOPCINA.idGradOpcina
HAVING (((tblGRADOPCINA.idGradOpcina)=[Forms]![Prijava oboljenja-smrti od zarazne bolesti]![Combo34]));"
lets say that querry counts 30 records,now i want to display that number in a text box on the form....how to do that?????
pls help
tnx
btw, all of the application is written in access, forms, and code, and all:)