Results 1 to 3 of 3

Thread: Count Function

  1. #1
    Join Date
    Mar 2004

    Unanswered: Count Function

    I need to calculated the total of person that I take in my table:Label. My table have a field or a primary key called Label Number(auto number) How I create a query...

  2. #2
    Join Date
    Mar 2003
    The Bottom of The Barrel
    Provided Answers: 1
    Try again.

    What are the fields in the table, and what do you need a count of.

  3. #3
    Join Date
    Jan 2004
    Toronto, Canada
    oh i get it; in the select query, just select that autonumber field, and click on the totals button on the top right; its a sigma sign if you cant find it;

    in the total field in ur query that pops up, just change it to "Count" and boom, u got the number

Posting Permissions

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