Results 1 to 7 of 7

Thread: Counting

  1. Mar 31st, 2001, 07:18 PM #1
    Ace
    Ace is offline

    Thread Starter
    Fanatic Member
    Join Date
    Feb 2001
    Posts
    759
    Hi Everyone,

    Is there a counting feature in MSAccess? I need to find out how many records there are for each member in a database table. Not, how many records there are all together. Any help would be appreciated. Thank you.
    Reply With Quote Reply With Quote
  2. Mar 31st, 2001, 07:20 PM #2
    Lethal
    Lethal is offline
    PowerPoster Lethal's Avatar
    Join Date
    Oct 2000
    Location
    Ohio
    Posts
    2,496
    Can't you use the Select Count(Member)
    Reply With Quote Reply With Quote
  3. Mar 31st, 2001, 07:25 PM #3
    Ace
    Ace is offline

    Thread Starter
    Fanatic Member
    Join Date
    Feb 2001
    Posts
    759
    Hi Lethal,

    I have never used the Select Count feature before. Can you explain a little more about how to use it? Thanks.
    Reply With Quote Reply With Quote
  4. Mar 31st, 2001, 07:27 PM #4
    Lethal
    Lethal is offline
    PowerPoster Lethal's Avatar
    Join Date
    Oct 2000
    Location
    Ohio
    Posts
    2,496
    Ok, first let me try to get this straight. You want the count for a specific field, correct ?
    Reply With Quote Reply With Quote
  6. Mar 31st, 2001, 07:31 PM #5
    Ace
    Ace is offline

    Thread Starter
    Fanatic Member
    Join Date
    Feb 2001
    Posts
    759
    Each Member has their own ID. I want to count to see how many times that members' ID shows up inside of the table. Then I want to move on to the next Member to see how many times their ID shows up in the list, etc. Does this make sense? Thanks for your help.
    Reply With Quote Reply With Quote
  7. Mar 31st, 2001, 07:34 PM #6
    Lethal
    Lethal is offline
    PowerPoster Lethal's Avatar
    Join Date
    Oct 2000
    Location
    Ohio
    Posts
    2,496
    How bout:
    Code:
    "Select Count(*) as Memeber_Num from TABLENAME Where MemberID = 5"
Msgbox RS!Member_Num
    Reply With Quote Reply With Quote
  8. Mar 31st, 2001, 07:38 PM #7
    Ace
    Ace is offline

    Thread Starter
    Fanatic Member
    Join Date
    Feb 2001
    Posts
    759
    Thanks Lethal. I'll try it out right now.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width