Report fun!

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

  • : 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.

Howdy, Stranger!

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

Categories

In this Discussion