how would I calc this?

[RET]

Ok Lets see if I can explain this problem. I have three fields in my database, One is the

[lakeside]

One way would be to define some fields with a set value, like sex_Male = "Male", sex_female = "Female", program_AD = "AD", race_Hispanic = "Hispanic", etc, etc

Then you make a self relationship called sex_Male where sex_Male = sex (that is, the field called sex_Male (with its preset value of "Male") equals all records where the sex question has the value "Male". And another self-relationship for each value you want to count.

Then you define yet another field as a calculation c_numMales = Count(sex_Male::recordID). And other fields for the other values. And that's the field you want to display.

It's a bit of work, but gives a decent amount of flexibility in formatting reports.

You can easily extend this to number of Males in program AD who are Hispanic. Just use sex.program.race = "Male AD Hispanic" as your constant and c_sex.program.race = sex & " " & program & " " & race

Again, a lot of work setting it up, but it gives you what you want.

[McCormick]

If you're working with limited options - if the ones you mentioned are all of them, plus a few more races - you can try combining them. Create a calc field of:

COMBINED = Sex & "." & Race & "." & Program

You can make a layout that is sorted by this calc field, and prints summaries underneath each subsummary. So you would get:

Male.Caucasian.AD

Female.Caucasian.AD

Male.Hispanic.AD

etc.

But you wouldn't show that field, you would just sort by it. This will work as a printout.

ALTERNATELY, this will let you focus on any one group very easily in Browse:

1) Create the calc field of (same as above):

COMBINED = Sex & "." & Race & "." & Program

2) create globals like

Sex.Search

Race.Search

Program.Search

which you can set manually, perhaps with value lists, for whichever criteria you want.

3) Calculation:

G_SEARCH = GetField (Sex.Search) & "." & GetField(Race.Search) & "." & GetField(Program.Search)

Now create a relationship between G_SEARCH and COMBINED.

This will let you show all of and only those records meeting whichever criteria you set. It only shows you one set of combinations, but you could build on it to expand.

[Fitch]

Why not just make a simple report?

1. Create 3 summary fields: Total of Program, Total of Sex, Total of Race.

2. Create a layout with 3 subsummary parts: by Program, by Sex, by Race

3. Put all 3 summary fields on each part

4. Sort and Preview