Multi Criteria Query

  • Thread starter Thread starter Rob
  • Start date Start date
R

Rob

Hi,

I have a couple of joined tables in a query which if run to return say the
number of people who started after 27/03/2004 works fine, however if I add
to the query the Sales field and Week Ending field from one of the tables
and set criteria to #19/03/2004#, the number of records returned is less
than previously. I think this is because some people don't have sales for
the 19/03/2004 but I would still like them included in my query once run.

Any ideas as to how I might achieve would be most welcome.

Rob
 
Sounds as if you're using INNER JOIN between the two tables; try changing to
an outer join (either LEFT JOIN or RIGHT JOIN, depending upon how the query
has been designed). You can do this in the design view of the query by
right-clicking on the appropriate join line, select Edit, and then select
the option that will give all records from the table with the sales people
in it, and only the matching records from the table with the sales in it.
 
Thank you for this Ken, didn't realise there was this option. However,
whatever I tried I couldn't get the necessary result; but I did read about
including an existing query within another query which looks to have done
the job.

Thanks again, Rob
 
Back
Top