C:\GYSTDOIT\JPG\FT_Statistics-Summary_FAMSIDE_DECEASED_SEX.htm

Tuesday December 1st, 2015 5:28 AM

Family Tree Statistics Summary

Objective:

Break out FT database by

Family Side
Deceased
Male/Female
as of this report date

Conclusion:

Information entered into the FT database should be accurate for
Family Side and Male/Female
but there is a fair amount of guess-work involved with classifying
Living from Deceased

There are no empty values for FAMSIDE, DECEASED and Male/Female fields
in the Family Member database
If you see incorrect information, please report to me for correction
at contact_me.htm
Thank You.

Descendent

STATUS	CNT
Living Women	25
Living Men	17
RIP Women	1
RIP Men	1

Father's Side

STATUS	CNT
Living Women	64
Living Men	71
RIP Women	43
RIP Men	46

Mother's Side

STATUS	CNT
Living Women	64
Living Men	73
RIP Women	53
RIP Men	52

SELECT padr(IIF(NVL(FAM_MEMBER.FAMSIDE,' ')='F',"Father's Side",IIF( FAM_MEMBER.FAMSIDE='M',"Mother's Side","Descendent")),50,' '), IIF(FAM_MEMBER.DECEASED, 'RIP ','Living ')+padr( IIF(FAM_MEMBER.MALE,'Men','Women'),10,' ') Status, count(*) FROM C:\JPG\FAM_MEMBER.DBF FAM_MEMBER GROUP BY FAM_MEMBER.FAMSIDE,FAM_MEMBER.DECEASED,FAM_MEMBER.MALE

SOURCE
URL:	,
Organization:
Date Acquired:	Tuesday December 1st, 2015 6:00 AM
Prepared By:	John Gaffey
Last Updated:	Tuesday December 1st, 2015 6:00 AM