id like to be able to do an append query

[rmoritzky]

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

Dan, Address, Phone, Employee Info
Mary, Address, Phone, Employee Info
Sue,Address, Phone, Employee Info
Terry, Address, Phone, Employee Info

And append (individual records) in a file formatted as:
Employee name, date of event, type of event. EG.

Dan, 10/01/05, Event
Dan, 10/02/05, Other Event
Sue, 10/01/05, Event
John, 12/01/05, Grand Event
John, 12/05/06, Grand Event
John, 12/06/07, Grand Event

Giving This, Eg.:

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

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

 

[Vincent Johns]

It's possible to create a Report that will do what you ask, but you will
quickly run out of space on your output device if you really want it all
on one line.

Much easier would be to put the personal information into one grouping
level of the Report, and put the event information into a lower grouping
level. Or, you could put the personal stuff into the Detail Section and
include a subreport linked to that person to contain the person's event
information.

-- Vincent Johns <[email protected]>
Please feel free to quote anything I say here.