[AccessD] Possible small paid project

Mine was even quicker and dirtier.  :-)

Between the two she should  be able to come up with a decent final result.

-- 
Stuart

On 14 Jul 2010 at 16:39, Darryl Collins wrote:

> 
> _______________________________________________________________________________________
> 
> 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.
> _______________________________________________________________________________________
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>