Access and appending records

[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 make that happen. The event information is not complicated
or lengthy at all but there may be as many as 10 events per person.

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

Thank you for reading my post.
Robert

 

[Arvin Meyer [MVP]]

If you do it properly, your records should look like this:

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

John, Address, Phone, Employee Info (end record)
12/01/05, Grand Event (end record)
12/05/06, Grand Event (end record)
12/06/07, Grand Event (end record)

Sue, Address, Phone, Employee Info (end record)
10/01/05, Event (end record)

Terry, Address, Phone, Employee Info (end record)

That's easily done in a report by using a subreport for the details and
gouping on the name. Ideally, you'd link the records on PersonID, not the
FirstName, since it's quite common to have multiple people with the same
name.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[rmoritzky]

thank you ive done that, but i think i need to have all dans info in one
record so i can do a mail merge on it, is it possible that a word mail merge
could take the records as youve given them to me and print dans info all
together on one letter on one sheet?

thanks again robert