query dillemma

[Guest]

Greetings. I am working in the query design view. I have 3 tables that I
need to bring together into a query for a report. The tables are;
tblClient,
tblRevenue,
tblUpdate.
In tblUpdate there is a topic field (Topic) that is a combobox list of
topics. There is also a note field (Note) that allows the user to put a note
in for the selected topic. All the tables are related. The Managing
Director is wanting a report that provides the note on 8 of the topics, plus
a few of the other fields. This report needs to resemble a spreadsheet look.
I can get the query to work with 1 of the notes for 1 of the topics. If I
add any others (same field) then I get an empty report.
I am not most experience person when it comes to queries so if some can walk
me thru or get me started I might be able to grasp it for any of the
remaining notes.
Thanks in advance for anyone responding.
*** John

 

[Tom Ellison]

Dear John:

I'm guessing your mistake may be in how you are trying to enter the "list of
8 topics" (to paraphrase).

First, using a combo box to pick 8 topics from a list is not possible.
Perhaps you're refering to the table view, but if this is a form, you'll
need a different control to be able to pick 8 topics. I'd recommend a
multi-select list box for that.

Without belaboring any more the things I'm guessing about your situation, I
think having you post the text of your query here (the SQL view of your
query will give this, and you can copy/paste it into your message) would
really speed this up. Please give us the working query for one topic as
well as the non-functional query for multiple topics. I expect we can
readily find the issue from that.

Tom Ellison