Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

How do I get M and F totals for a Gender field in Access?

Discussion in 'Information Technology' started by Celinda, Jul 28, 2006.

  1. Celinda

    Celinda
    Expand Collapse
    Guest

    I'm a new Access 2003 user, working with a file of over 500,000 records. I'm
    wanting to determine how many Males and how many Females from a Gender field
    and can't figure out how to do this seemingly simple task.
    Thanks.
     
  2. Loading...

    Similar Threads Forum Date
    Hard Talk Gender Inequality In Sikh Rehat Maryada? Hard Talk Oct 23, 2009
    Female Spirit In Male Bodies And Vice-versa. And The Genderless Brahman Hard Talk Apr 28, 2016
    Hard Talk Male Domination, Gender Discrimination In Sikhism Hard Talk Apr 18, 2016
    Controversial The Gender Trap Hard Talk Jul 3, 2014
    Urgent! Need help with some gender equality questions! Questions and Answers Jan 7, 2013

  3. Wayne-I-M

    Wayne-I-M
    Expand Collapse
    Guest

    =IIf(Count([GenderField])="M","Total Males"&" "&[GenderField]),)
    =IIf(Count([GenderField])="F","Total Females"&" "&[GenderField]),)


    --
    Wayne
    Manchester, England.



    "Celinda" wrote:

    > I'm a new Access 2003 user, working with a file of over 500,000 records. I'm
    > wanting to determine how many Males and how many Females from a Gender field
    > and can't figure out how to do this seemingly simple task.
    > Thanks.
     
  4. Jerry Whittle

    Jerry Whittle
    Expand Collapse
    Guest

    SELECT tblEmployees.Gender, Count(tblEmployees.Gender) AS GenderCount
    FROM tblEmployees
    GROUP BY tblEmployees.Gender
    ORDER BY tblEmployees.Gender;
    --
    Jerry Whittle
    Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

    "Celinda" wrote:

    > I'm a new Access 2003 user, working with a file of over 500,000 records. I'm
    > wanting to determine how many Males and how many Females from a Gender field
    > and can't figure out how to do this seemingly simple task.
    > Thanks.
     
  5. Celinda

    Celinda
    Expand Collapse
    Guest

    Thank you to Wayne and Jerry for responding.

    I actually was able to do what I needed by following the directions of Ed
    Warren from someone else's inquiry:

    1. Open the query designer
    2. Add your table to the designer
    3. Add the field 'gender'
    4. Add the primary key field, e.g., "id"
    5. Select the Groupby (totals) icon (sigma)
    6. Under 'gender' select "Groupby"
    7. Under ID select "Count"
    8. Run the query
    It returns a count of the number of each gender in the database

    9. For even more specific information from your table, add another field,
    e.g., "race"
    10. Run the query

    Now it returns a row for each combination of 'gender' and 'race' with a
    count of the number of records in the 'group'

    This worked for me!!! YAY!! and thanks.

    "Jerry Whittle" wrote:

    > SELECT tblEmployees.Gender, Count(tblEmployees.Gender) AS GenderCount
    > FROM tblEmployees
    > GROUP BY tblEmployees.Gender
    > ORDER BY tblEmployees.Gender;
    > --
    > Jerry Whittle
    > Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.
    >
    > "Celinda" wrote:
    >
    > > I'm a new Access 2003 user, working with a file of over 500,000 records. I'm
    > > wanting to determine how many Males and how many Females from a Gender field
    > > and can't figure out how to do this seemingly simple task.
    > > Thanks.
     

Share This Page