Results 1 to 4 of 4

Thread: Count (2000)

  1. #1
    2 Star Lounger
    Join Date
    Dec 2002
    Posts
    192
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Count (2000)

    Hi, Access is very new to me. First can any one tell me where I can go to find the formulas that access uses? The problem I

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Count (2000)

    You can create expressions in Access queries, forms and reports - they are the equivalent (more or less) of formulas in Excel. You can use functions in expressions, but they are not the same as Excel worksheet functions. Access has an Expression Builder that helps you to create expressions. Type expression builder in the Answer Wizard to learn how to use it.

    Access is very different from Excel; there is a Count function, but no COUNTA function. If you explain what you want to accomplish, we may be able to offer more specific help.

  3. #3
    2 Star Lounger
    Join Date
    Dec 2002
    Posts
    192
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Count (2000)

    Thanks for getting back to me. What I'm trying to do is with in a query try to find a way for access to tell us how many employees are working for each employer. I set the criteria for lets say John It will give me all the employees for John but I still have to count them by hand. We would like it so if you typed in the employer is would tell you how many employees they have working under them.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Count (2000)

    Create a new query based on your table.
    Add the Employer field and the Employee field to the query grid.
    Select View | Totals, or click the Totals button on the toolbar.
    Leave the Totals option for the Employer field as Group By, and set it to Count for the Employee field.
    Now switch to datasheet view.
    Is this what you wanted?

Posting Permissions

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