I've got a database that has got records that are sorted into different categories. I want to have a TOC page that looks something like this:<BR><BR>category (# records in category)<BR><BR>is this possible?<BR><BR>TIA
Sorry, maybe I didn't make it clear wanted I wanted to do. I want to be able to have a page which has something like this:<BR><BR>Apples (12)<BR>Bananas (20)<BR>Pears (9)<BR><BR>etc. (where apples is a category name)<BR><BR>Count(*) only gives me the total number of records in the database, rather than a break-down of each category.