[AccessD] Possible small paid project

Darryl Collins Darryl.Collins at iag.com.au
Wed Jul 14 00:25:59 CDT 2010


_______________________________________________________________________________________

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



I would be willing to have a look at this for you.  If the client does want to pay anything, can you please donate any loot to Access-D.
You can email any more details off list if you want.

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




More information about the AccessD mailing list