Results 1 to 3 of 3
  1. #1
    Join Date
    May 2005
    Posts
    126
    Provided Answers: 1

    Question Unanswered: Show count of records on a form

    I need a bit of guidance please, I am collecting data within one table on service calls against motors, KardexTbl, the fields include KardexID(AutoNumber), Serial Id, Date and Description.

    I have created a form showing the above fields, no problem there I manually added an unbound text box, and put in =count([KardexID], which is great it counts the number of records in the whole table, but what I want it to do is count the number of records against the specific “SerialId”, how do I do this

    Thanks

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    You can use a DCount:

    General: DLookup Usage Samples
    Paul

  3. #3
    Join Date
    May 2005
    Posts
    126
    Provided Answers: 1
    Thank you for your help

Posting Permissions

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