TMG-L Archives

Archiver > TMG > 2000-03 > 0952284568


From: "Thomas W. Taylor" <>
Subject: Re: TMG-L: Death Date Analysis
Date: Sun, 05 Mar 2000 14:29:28 -0500


The following is the SQL for defining the query for this analysis. The
"TAYLOR_$" & "TAYLOR_N" refer to linked tables in the Access DB. Your
names will vary depending on your DB, but use the "_$" & "_N" Foxpro
(TMG) tables. "SPLIT" is a custom flag I have defined which helps me
select records from the DB; you can ignore this if you choose.

SELECT
TAYLOR_N.NAME, Right$(Left$([PBIRTH],9),8) AS BDate,
Right$(Left$([PDEATH],9),8) AS DDate,
CVDate(Mid$([BDate],7,2)+"/"+Mid$([BDate],5,2)+"/"+Mid$([BDate],1,4)) AS
BDateN,
CVDate(Mid$([DDate],7,2)+"/"+Mid$([DDate],5,2)+"/"+Mid$([DDate],1,4)) AS
DDateN, DateDiff("d",[BDateN],[DDateN])/365.2425 AS Age,
Int((([Age]-Int([Age]))*365.2425)+0.5) AS Expr3,
CInt(Mid$([BDate],1,4)) AS BYear,
[TAYLOR_$].PER_NO
FROM [TAYLOR_$]
INNER JOIN TAYLOR_N ON [TAYLOR_$].PER_NO = TAYLOR_N.NPER
WHERE ((([TAYLOR_$].PBIRTH) Like "11???????030000000000" AND
([TAYLOR_$].PBIRTH) Not Like "???????00030000000000") AND
(([TAYLOR_$].PDEATH) Like "11???????030000000000" AND
([TAYLOR_$].PDEATH) Not Like "???????00030000000000") AND
(([TAYLOR_$].SPLIT)="Y"));

Cheers,
twt


J. O'Neall wrote:
>
> >
> > With TMG it is easy to perform this analysis, since the DB is Foxpro,
> > Bob V has so nicely distributed the database attribute defiintions
> > (thanks Bob!!!) and links can be made to an Access 97 database, queries
> > defined & performed and the data extracted and analysed with MS Excel
> > 97.
> ...
> >
> > Other people with the required s/w (TMG, Access 97 & Excel 97 with the
> > data analysis pack) might like try a similar analysis on their data. If
> > there is interest I can post the requisite Access query definitions.
>
> Yes, I would like that, please. Thanks in advance. John
> --
> John O'Neall
> Genas, France
> http://homepages.rootsweb.com/~joneall/
>
> >
> > Cheers,
> > twt
> > --------------------------------------------------------------------------
> ---
> > TMG-L The Internet Mailing List for The Master
> Genealogist
> > To unsubscribe: Send an e-mail to with 'UNSUBSCRIBE
> TMG-L'
> > or... if you get the digest version: 'UNSUBSCRIBE
> TMG-L-DIGEST'
> > --------------------------------------------------------------------------
> ---
> >
>
> -----------------------------------------------------------------------------
> TMG-L The Internet Mailing List for The Master Genealogist
> To unsubscribe: Send an e-mail to with 'UNSUBSCRIBE TMG-L'
> or... if you get the digest version: 'UNSUBSCRIBE TMG-L-DIGEST'
> -----------------------------------------------------------------------------
- ---------------------------------------------------------------------------
TMG-L The Internet Mailing List for The Master Genealogist
To unsubscribe: Send an e-mail to with 'UNSUBSCRIBE TMG-L'
or... if you get the digest version: 'UNSUBSCRIBE TMG-L-DIGEST'
- ---------------------------------------------------------------------------

This thread: