PDA

View Full Version : ...RecordCount...

dblinux
05-24-02, 04:55
I've got to count the rocrds of this query (SELECT DISTINCT lm.idlm, lm.descrizione FROM lm, grf, saf, cfc WHERE cfc.idlm = lm.idlm AND cfc.idsaf = saf.idsaf AND cfc.idgrf = grf.idgrf) but i can't use the function RecordCount of Visual Basic... how can I do???

Please Help ME! :(
smooth
05-29-02, 09:03
you can do it very easy with the sql count function..E.G.:

select your_filed1, your_field2, count(your_field1) from your_table;

Hope that help you..
Smooth