I'm starting this as a new thread although it follows on from Copying Tables - a good or bad thing.

Here's what I'm trying to do, maybe someone could point me in the right direction.

I work for a small charity and we need to collect evaluation data from people we work with so we can report to our funders. For example we run training events and need to collect equal opportunities data from those who attend: sex, age, ethnicity, whether they're disabled or not, sexuality, and so on.

I started creating a database thinking I could create fields for all of these things with associated value lists to allow people to choose what sex people were when entering data. What I couldn't work out was how to count up how many men and how many women, for example, from the data.

I can't define a field for Men and one for Women and then count do a simple count of each field as there are too many fields to fit on a layout. One piece of data we need to collect is how many people come from certain boroughs in London - there are 33 boroughs so I'd have to define 33 fields!

Has anyone got any suggestions?

Thanks

Why you dont want search by sex field for choosing and calculating your Mens and Womens such as:

Enter find mode

Set field Sex "Men"

Perform find

May be i dont understood you.

Columnar List Layout with leading part based upon your Sex field. Then create summary on this field, selecting Count (place in leading part). Once report is created, you can even delete the body and just leave the leading part. Sort by Sex field and it will display:

Lead Part: Men Count: 36

Lead Part: Women Count: 39

Works with all Value Lists.