Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

Report fun!

Anthony AAnthony A Member Posts: 8
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)

Next...

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 Name:
Speaker Average q_1:
Speaker Average q_2:
Comments recieved:

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.

Anthony

Comments

  • aatkbdaatkbd Member Posts: 42
    : 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)
    :
    : Next...
    :
    : 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 Name:
    : Speaker Average q_1:
    : Speaker Average q_2:
    : Comments recieved:
    :
    : 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.
    :
    : Anthony
    :

    Go into the access help files and put in the following keywords:

    group; report;

    you should be able to find all the information you need to fix your problem.
Sign In or Register to comment.