[AccessD] Possible small paid project

Kathryn,

Is it correct to assume that the Father_ID, Mother_ID and Spouse_ID
fields are self-joins to the Person_ID records for the related
individuals?  Are there records in the excel file that represent those
individals?  If so, it's pretty much a matter of importing the excel
files into an Access database and creating the necessary joins, then
querying out the data you want.

Charlotte Foust

On Tue, Jul 13, 2010 at 9:26 PM, Kathryn Bassett <kathryn at bassett.net> wrote:
> I have an Excel spreadsheet with the following columns:
>
> Person_ID
> LNAME
> FNAME
> SEX
> STREET
> CITY
> STATE
> ZIP
> COUNTRY
> Father_ID
> Mother_ID
> Spouse_ID
> BirthDate
> BirthPlace
> MarriageDate
> MarriagePlace
> DeathDate
> DeathPlace
> NOTES
> MEMO
>
> I'm not concerned with turning date fields into proper dates because they
> aren't important to the grand scheme of things. And there is some info in
> some of the fields that don't fit the field descriptions. That's not
> important either. What needs doing by someone with knowledge on how to do
> it, is to link the ID's and make a report that will show all the person's
> data including their father/mother/spouse NAME instead of ID number. There
> are about 7800 records.
>
> It comes from a very very old dos genealogy program that is not capable of
> making a gedcom file
> (gedcom: http://en.wikipedia.org/wiki/Gedcom)
>
> I'm trying to help the lady preserve the data and she's not computer
> literate. At this point, it probably won't go into another genealogy
> program, I'll just make a pdf of the resulting report.
>
> I think I can get her to authorize $100 to take care of this. So, does
> anyone feel they can write a query and report to do what I need done? If so,
> I'll let you know off-list the location of the Excel file once I have the
> go-ahead from her for the money (unless you want to do it for free like I'm
> doing).
>
> BTW, I have Access2007 with which to open your mdb.
>
>
> --
> Kathryn Rhinehart Bassett (Pasadena CA)
> "Genealogy is my bag" "GH is my soap"
> kathryn at bassett.net
> http://bassett.net
>
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>