Access and appending records and Excel into Word Mail Merge

[rmoritzky]

I would like to take a file formatted generally as:
Employee name, employee info. EG:

Dan, Address, Phone, Employee Info (end record)
Mary, Address, Phone, Employee Info (end record)
Sue, Address, Phone, Employee Info (end record)
Terry, Address, Phone, Employee Info (end record)

And append date and event information in a file formatted as:
Employee name, date of event, type of event (end record) EG.

Dan, 10/01/05, Event (end record)
Dan, 10/02/05, Other Event (end record)
John, 12/01/05, Grand Event (end record)
John, 12/05/06, Grand Event (end record)
John, 12/06/07, Grand Event (end record)
Sue, 10/01/05, Event (end record)

Giving This, EG:

Dan, Address, Phone, Employee Info, 10/01/05, Event, 10/02/05, Other Event
(end record)
Mary, Address, Phone, Employee Info (end record)
Sue, Address, Phone, Employee Info, 10/01/05, Event (end record)
Terry, Address, Phone, Employee Info (end record)

I am able to process the files in access, and I have done reports, forms,
queries. I was told that what I want could be done in a report but I have
not been able to get the info ON ONE RECORD or one line as you prefer. The
event information is not complicated or lengthy at all but there may be as
many as 10 events per person. I would like each persons info on one line so
that I can do a word mailmerge and print one letter with all ofr each persons
information on the same page.

I am using Office 2003 Pro at home and Office 2002 Pro at the Office.

Thank you for reading my post.
Robert

 

[KARL DEWEY]

Access is a relational database. Events would be related to employee - not
in the same record.
Add a EmpID field to your table. Use datatype Autonumber and make it the
key field.

Use a second table for events.
Event --
EventID - autonumber - key field
EventName - text - title of event
Descripton - text - narrative
EventDate - datetime

Third table for employee to events.
EmpEvent--
EventID - number - interger
EmpID - number - interger

Set relations one-to-many from Employee to EmpEvent table on EmpID.
Set relations one-to-many from Event to EmpEvent table on EventID.

 

[rmoritzky]

thank you veruy much for your help

Access is a relational database. Events would be related to employee - not
in the same record.
Add a EmpID field to your table. Use datatype Autonumber and make it the
key field.

Use a second table for events.
Event --
EventID - autonumber - key field
EventName - text - title of event
Descripton - text - narrative
EventDate - datetime

Third table for employee to events.
EmpEvent--
EventID - number - interger
EmpID - number - interger

Set relations one-to-many from Employee to EmpEvent table on EmpID.
Set relations one-to-many from Event to EmpEvent table on EventID.