Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2008
    Posts
    4

    Unanswered: A Summary query in Access

    Hi All,

    I would like to create a query that will tell me how many males and how many females there are in each table with a summary query.

    The tables are:

    tbl_course (1) -------------- (Many) tbl_student

    So id like to find out how many males and how many females there are in each course. I can't for the life of me figure out how to do this (it seems like it should be so easy).

    Thanks alot for your time

    Folly

  2. #2
    Join Date
    May 2005
    Posts
    1,191
    First off, I assume you're storing this data somewhere (a Yes/No field)? That would be helpful info.

    Secondly, this wouldn't happen to be a homework problem would it?

    Post with what you've got so far, we'll help you as best we can from there.
    Me.Geek = True

  3. #3
    Join Date
    Nov 2008
    Posts
    4
    I'm storing whether or not someone is a male or female in the tbl_student under "sex".

    This is what I've done so far (see attached images).

    But it seems as though it's not adding up correctly, any help would be appriciated.

    Aside (This is a form of homework, I'm hoping to use this in a works database - hope it's ok to post here)
    Attached Thumbnails Attached Thumbnails query.jpg   query2.jpg  

  4. #4
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Why do you think it's wrong?
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

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