[AccessD] Possible small paid project

Hello Kathryn,

>From reading the other messages on AccessD I see that you have gotten your
solution. What a value this list is. Please ignore my previous message.

Doug 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kathryn Bassett
Sent: Tuesday, July 13, 2010 9:26 PM
To: 'dbAdvisors (AccessD)'
Subject: [AccessD] Possible small paid project

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