Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2003
    Posts
    292

    Unanswered: Counting in a module

    I have a module .. that counts the first two letters in my field "INSP"

    module:
    Code:
    Function funCount1(prmSearchString As String) As String
        funCount1 = DCount("[INSP]", "[qryQualityStatus]", "left([INSP],2) = '" & prmSearchString & "'")
    End Function
    I insert this code in my report as follows..

    Code:
    =funCount1("DR")
    in a txt box ... this would count all "DR" in my "INSP" field and display the number..

    Now I need the count of all data with "DR" (or the first two letters in my INSP field) AND a COUNT REJ of "Y"
    REJ would be another field in my table. Both have to be met and a count of that set of records..

    help please thanks..

  2. #2
    Join Date
    Jun 2002
    Location
    Houston, TX
    Posts
    116
    Why not do a query and put the criteria for INSP=like "DR*" and "Y" for the other field.

    HTH
    texasalynn

Posting Permissions

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