Results 1 to 2 of 2

Thread: recordcount

  1. #1
    Join Date
    May 2002
    Location
    Italy
    Posts
    36

    Unanswered: recordcount

    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!

  2. #2
    Join Date
    Jul 2001
    Location
    Germany
    Posts
    189
    Hello,

    what´s about

    SELECT COUNT(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


    ?

    Hope that helps ?

    Manfred Peter
    (Alligator Company)
    http://www.alligatorsql.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •