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.
Printable View
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.
Can't you use the Select Count(Member)
Hi Lethal,
I have never used the Select Count feature before. Can you explain a little more about how to use it? Thanks.
Ok, first let me try to get this straight. You want the count for a specific field, correct ?
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.
How bout:
Code:"Select Count(*) as Memeber_Num from TABLENAME Where MemberID = 5"
Msgbox RS!Member_Num
Thanks Lethal. I'll try it out right now.