formula

[wdisneymom]

I have a database with records of clients and want to do a report calculating different fields(age,gender,custody etc)

I am a newbie and don't know where to begin to summarize these fields

Any help???

[mr_vodka]

Can you provide more information on exactly what and how you want on your report.

Thanks.

[wdisneymom]

Thanks,

I want to total the number of kids from each county, the gender of each kid (how many males, females) how many are in parent custody, social services custody etc

[Kent Searight]

Sounds like you want to do a Summary report.

Create a new layout by selecting New Layout/Report under Layouts in the Menu Bar. Select Columnar List/Report as your layout type, and just follow the instructions for how to divide up your summaries.

Also, you'll want to create 1 summary field to get the Count Of a field you know will never be empty (auto-enter serial #).

Try this out and see if it makes sense. Let us know if you get stuck.

[mr_vodka]

Hi as Kent stated, you need to run summary reports. Here is a mockup file that you can disect and take a look at.

Happy holidays!

reports.zip

[wdisneymom]

looks great

Thanks so much I will try both ways

[wdisneymom]

I've been trying to replicate your report

when I look at your defined fields I see "cCount" and "SJ_age" etc. cCountCounties ( SJ_county::PersonID )

What does the "cCount" mean

What does SJ_county mean

[mr_vodka]

cCountAge is the name of the calculation field which formula is: Count ( SJ_age::PersonID )

This is basically the count of all the PersonIDs based off the 'self joining' relationship that I called SJ_age. Take a look at the relationships graph.

The self joins are based off of the value of the current record and then the count function counts all records that match the value of the current match field. In other words, if the current record has the value of 5 in the age field, the self join matches all records that have the value 5 in it. Then the calcuation counts the number of records that has 5 for the age in it.