Two tables, losing records

[Matt Dawson]

I currently have a query which has sums based on whether a quote has been
sent, in action, or rejected. I have built totals of these with percentages
based on the overall number of quotes being dealt with.
However, I need to add data from a different table with the amount of money
raised from quotes which have been sent. As soon as i even include that table
in the query, all the data for quote in action and quote rejected disappears
and leaves me only with quote sent data. I think this is due to the join
between the two tables, which is based on Serial ID.

Any ideas as to how i can include all the data in this query?

Matt

 

[Jerry Whittle]

You are doing an Inner Join when you need either a Left or Right Join.

In the design view of the query double click on the line between the two
tables until a dialog box comes up. Pick the second option and see if that
works. If not, pick the third join option.

 

[Matt Dawson]

Jerry, I cant believe I didnt tihnk of it myself!
Thats brilliant much appreciated