Please could someone help me figure this out:

I need to be able to establish how many records are showing the selection of a certain option from within a value list. For example, if i have a value list of states, I want to be able to find out how many records have 'NSW'' selected from the state value list, how many have 'QLD' selected etc. Basically i think i need to be able to work out how to extract the selection of a item within a value list for a number of different fields which may use pop-up lists or radio buttons etc.

Ultimately I am aiming to be able to extract these deatils for a found set of records.

Any Ideas?

If you want to show it for the record you currently have selected, create a self-relationship based on the state field, and then define a new field as count(relationship::state) If you are viewing a record from NSW, then this field will show the total number of records from NSW, when you move to a record from QLD, it will show all the banana benders etc. This will work on all records - not only on the found set.

If you want a report list of your people by state, create a layout with a sub-summary (sorted by state) part and no body part. In the sub-summary part, place the State field and a new field StateCount (summary field) which = Count of State.

Then, sort your records by state and go to this new layout and enter preview mode. You will see (depending on how you sort the states):

ACT 107

NSW 216

QLD 124

VIC 326

etc

This sub-summary report will work on the found set.

O.K I think i understand. The only thing is what i want to do is have a variety of information on one layout. For example i have several calculation fields which workout the average age of the found set etc. I have also fields with value lists of medical symptoms. What i would like to do is have the database tell me how many records in the found set have a certain symptom selected, and have this appear on the same layout as the calculated fields. Is this possible or am i confusing you as much as i am confusing myself

?!

Thanks,