Reply to thread

Message: [QUOTE="rmoritzky, post: 895774"] 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 [/QUOTE]