Computing.Net > Forums > Office Software > Count Records in a Access Table

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

Count Records in a Access Table

Reply to Message Icon

Name: Qbart
Date: October 25, 2003 at 18:49:53 Pacific
OS: 98se
CPU/Ram: 750/320
Comment:

I have an Access table with 1600 records in it. What I want to do is be able to count how many records there are of a certain type. For example I have 6 different entries in a genre field. Rock, Country, Oldies, Pop, Classical and Techno. I want to be able to find out how many records I have of each genre. How could I do this?

Thanks



Sponsored Link
Ads by Google

Response Number 1
Name: Qbart
Date: October 26, 2003 at 09:14:33 Pacific
Reply:

OK, I went ahead and just used a pivot table!



0
Reply to Message Icon

Related Posts

See More







Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Office Software Forum Home


Sponsored links

Ads by Google


Results for: Count Records in a Access Table

Hide zero values in a Pivot Table www.computing.net/answers/office/hide-zero-values-in-a-pivot-table/6188.html

Select specific Records in Access 2 www.computing.net/answers/office/select-specific-records-in-access-2/4560.html

Selecting records in MS Access www.computing.net/answers/office/selecting-records-in-ms-access/5239.html