I have (in Access 2002)
Table 1 called SongTitles containing the fields SongTitleID and Song Title
Table 2 called Writers containing the fields WriterID, WriterFirstName and WriterLastName
Table 3, a junction table linking SongTitleID and WriterID both one to many from SongTitles and Writers to Table 3
My simple query answer table gives me
People Are Strange Alan Smith
People Are Strange Billy Jones
which is fine because I display this information on a form which only shows the title once
HOWEVER
A third party company would like me to send my data to them on an excel sheet in a format where the info is contained in a single row
SongTitle; Writer 1 First Name; Writer 1 Last Name; Writer 2 First Name; Writer 1 Last Name
It would come out as
People Are Strange; Alan; Smith; Billy; Jones
Can anyone please tell me if there a way of creating a new answer table in this format for exporting the data into excel.
Help very gratefully appreciated
peter