Noob needs help!

[David B]

OK, here's my issue:

I have a FM8.5 database with over 300k records. Each record is assigned to a subject area using a "subject Area" field. The subject area field uses a drop-down list (populated from another table) of roughly 126 subject areas.

I need to figure a way to generate a report that will take the entire database as the found set, then report:

1. The total number of subject areas.

2. The total number of records assigned to each individual subject area.

I tried using the count function, but can't seem to get it to work correctly. If anyone has any pointers or knows of an example that may be relevant, I'm all ears. Thanks!

-David

[Vaughan]

Create a summary report, bsed on the Subject Area field.

As a starter, the new layout wizard thingy will lead you through the process.