hi

i am doing a recruitment database where i have 4 tables, the first is the applicants, then staff, then interviews, then interviewers

currently i have

tblStaff
StaffID, pk, autonumber
StaffFirstName
StaffLastName
etc... (you don't need initials because you can get them from the first and last names)

tblApplicants
ApplicantID, pk, autonumber
ApplicantFirstName
ApplicantLastName
etc...

tblInterviews


InterviewID, pk, autonumber
InterviewDate
ApplicantID, fk
etc...

tblInterviewers
InterviewerID, pk, autonumber
InterviewID, fk
StaffID, fk
Comments
etc...

It works fine. However my problem comes when i have producing queries. I am trying to get a list of all the people who are to be interviewed and by who. However more than one person may interview them.

In the queries i have made for an interview that has two interviewers i get two separate lines. However i wish to combine these and have an extra column for the second interviewer

any help?