Family Member Status - Names with Faces

Objective:

Note statistics for possessing portrait valid image file for each individual family member in the family tree database.

Conclusion:

This report covers all records in FAM_MEMBER.DBF
Statistics, as of this report date, are cited below.
We have fairly complete set of faces for Descendents
We only have pictures a third (or less) of living members on Fathers and Mother's side

DM	DW	FM	FW
MM	MW

DM

GENDER	STATUS	PHOTO	CNT
Men			15
Men	RIP		2

Top

DW

GENDER	STATUS	CNT
Women		2
Women		23
Women	RIP	1

Top

FM

GENDER	STATUS	CNT
Men		70
Men		16
Men	RIP	48
Men	RIP	7

Top

FW

GENDER	STATUS	CNT
Women		50
Women		21
Women	RIP	35
Women	RIP	11

Top

MM

GENDER	STATUS	CNT
Men		61
Men		42
Men	RIP	42
Men	RIP	22

Top

MW

GENDER	STATUS	CNT
Women		79
Women		41
Women	RIP	45
Women	RIP	22

Top

SELECT FAM_MEMBER.FAMSIDE+ IIF(FAM_MEMBER.Male,'M','W') , padr( IIF(FAM_MEMBER.Male,'Men','Women'),40,' ') Gender , IIF( FAM_MEMBER.DECEASED,'RIP','') Status, IIF( !EMPTY(FAM_MEMBER.PHOTO),'<img src=CHECKMRK.ico>','' ) Photo, count(*) FROM C:\JPG\FAM_MEMBER.DBF FAM_MEMBER GROUP BY 1,2,3 ,4

SOURCE
URL:	,
Organization:
Date Acquired:	Monday February 1st, 2016 12:17 PM
Prepared By:	John Gaffey
Last Updated:	Monday February 1st, 2016 12:17 PM