Okay guys, I got a bit of a problem for you.
Right now, I have the following database schema:
Session(SessionID, SessionName, Date, Address, City, State, Zip)
Speaker(SpeakerID, SpeakerName, Address, City, State, Zip)
SessionEval(ID, SessionName, q_1, q_2 q_3, comments)
SpeakerEval(ID, SpeakerName, SessionName, q_1, q_2, comments)
I have generated a query to compute the average of q_1 and q_2 of SpeakerEval. That was easy.
I have generated another query to grab all of the comments of the speakers. Once again. That was easy.
I now want to generate a report that has the following format:
Speaker Average q_1:
Speaker Average q_2:
The problem is with the comments recieved. I want the speaker name to appear only ONCE. I was to list all of the comments for that particular speaker. If I just do an outter join of these two queries, I get duplicates of the Speaker name and averages.
Any ideas? I appreciate any help ANYONE can give me.