[AccessD] Possible small paid project

_______________________________________________________________________________________

Note: This e-mail is subject to the disclaimer contained at the bottom of this message.
_______________________________________________________________________________________


Hi Kathryn

I have whipped up a cheap and nasty result for you and emailed you offlist with a zip file.

Some points to note:

There were about 7 original records in the spreadsheet all with the KeyID of 1, I have incremented these to the end of the existing id list.
One record had a KeyID of 0, I changed this entry to KeyID 1

There is plenty of dirty data in the spreadsheet, especially in the address fields where users have basically added any ol comment in there.  You are going to need to clean it up. I would suggest adding another field(s) to the main data table in Access and move any non address data into the new note(s) fields.

I would recommend putting in some logic to clean up any output data that is messy (such as legacy "()" in the output where where no data exists etc).

This is not perfect, but it should be close enough for you to do something with.  Hopefully my northern friend (Stuart) is having a lazy day and can spend a bit more time on it for you.

Cheers
Darryl.



 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kathryn Bassett
Sent: Wednesday, 14 July 2010 3:12 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Possible small paid project

Darryl Collins asked:
> Just want to clarify.  You want to load the Excel data in MS Access?
> Or just link the ID from Excel to Access?
> Or Using the ID in Access as a Key, Update all the additional data from
> Excel to Access using the ID?
> Not 100% clear on what you are after here, but if it is what I am
> thinking it should be easy and painless to do.

The end result would be a report that shows the following in alpha order:

Bassett, Kathryn (LName, FName concatenated, then after name should be the
sex designation with () around it)
(next line contents of Street City State Zip Country, concatenated)
Father: John Doe (name found by looking up the number in the Father_ID field
in the Person_ID field, to get the name)
Mother: Jane Smith (same scenario)
Spouse: David Bassett (same scenario)
Born: (contents of BirthDate and BirthPlace fields, concatenated)	
Married: (contents of MarriageDate and MarriagePlace fields, concatenated)
Died: (contents of DeathDate and DeathPlace fields, concatenated)
Notes: (contents)
Memo: (contents)

Next record

Next record

Next record until done.

So, however it's done doesn't matter to me as long as I can get the result
in a Word (or WordPerfect) file. From there, I'll add headers and other
things I'll want to add before making the pdf.


--
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
_______________________________________________________________________________________

The information transmitted in this message and its attachments (if any) is intended 
only for the person or entity to which it is addressed.
The message may contain confidential and/or privileged material. Any review, 
retransmission, dissemination or other use of, or taking of any action in reliance 
upon this information, by persons or entities other than the intended recipient is 
prohibited.

If you have received this in error, please contact the sender and delete this e-mail 
and associated material from any computer.

The intended recipient of this e-mail may only use, reproduce, disclose or distribute 
the information contained in this e-mail and any attached files, with the permission 
of the sender.

This message has been scanned for viruses.
_______________________________________________________________________________________