Okay.....

Once again, I'm sure I'm missing something fairly obvious but, I suspect, I'm standing "too close to the trees".

Here's the background info ----

Database Type -> Seminar Reservation/Attendance

Field Info (Fields to be reported on/considered);

Household Position (HshldPoz) - Text (by Value List)

Value List -

[*]Head of Household

[*]Spouse

[*]Youth

[*]Child

[*]Speaker

[*]Other

Day of Attendance (DayStay1 - DayStay8) - Check Box (Y/N)

Other data;

- DayStay(x) will be corrolated to a date in the finished product.

- HshldPoz must be a value list since each type is used to calculate seminar cost.

Assumptions;

For HshldPoz value list, all types except Child & Youth are considered Adult attendees.

THE PROBLEM *groan*

I need to publish a report that will show how many Adults/Child/Youth will be attending each day with a Summary field for each column (see example below. Pardon the periods, UBB Code doesn't do tabs and spaces very well.)

.........DayStay1........DayStay2.......DayStay3..(etc)

Adult........4(AdltSt1).....2(AdltSt2).....1(AdltSt3)

Youth.......2...................1..................4

Child........1...................4...................2

-------------------------------------------------------

Totals.......7..................7...................7

Now the totals won't be a problem since it's a simple summary field but I'm having a real problem getting the other data elements (AdltSt1, YthSt1, etc) to calculate. I've tried Count(field) and Sum(field) without much success. Any assistance will sure be appreciated.

Dan

There are several ways to create such a report, but you didn't tell us how the date1, date2, date3 were populated.

Are these date1 current field names ?

Are the globals populated by a script based on the seminar dates ?

Do you want to have a sub-list of names in a body part, or do you just want the counts to appear ?

For a Total Summary, you could use a concanation "Category&Date" and a script (looping through each categories and each range) could set each value from the result of count(selfJoinonConcanation::field).

Depending on the number (range) of dates you need to make appear, you could also have a set of say 7 dates, and if needed script a Day+ or Day- to have these fields populated.

Just some ideas...

You'd need :

g_DatefieldCounter

g_date1, g_date2,....

g_valuechosen

cg_concanation = g_DatefieldCounter&"-"&g_valuechosen

The script sets in a loop each date and

One solution I'd consider would be to script any entry using relationships.

For example, set all dates to be a global and use a g_category field.

If any date is a global, use a concanation g_date1&Category