Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2002
    Posts
    14

    Unanswered: Counting Records in a Form

    Can someone show me the correct syntax to use in a form's text box record source that will count the number of records in a query?

    Thank you.

    alfman

  2. #2
    Join Date
    Aug 2002
    Location
    Arkansas
    Posts
    13
    If you want to count the number of records of the record source of the form then set the record source of the text box as follows:

    =Count(*)

    OR

    if it is not the record source of the form:

    =DCOUNT("[field to count]","domain","criteria")

    The example below would count the number of carriers in my CARRIERS file where state equal AR:

    =DCOUNT("[CarrierNo]","CARRIERS","[STATE]='AR'")




    Look in HELP for more details.

    Tag

Posting Permissions

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