Display all Records

  • Thread starter Thread starter Chuck Moore
  • Start date Start date
C

Chuck Moore

I have several queries that return staff that meet certain
criteria. I sometimes ned to show all staff, even through
they don't meet the criteria and I would like to display a
blank or a zero in the total column after their names. Is
there a way to force the query to show all staff names
form the staff table?
 
More than likely, all you need to do is copy one of your other queries and rename it, and remove the criteria from it. Sorry if I missed your point..

<-*-><-*-><-*-><-*-><-*-><-*-><-*-><-*-
Hope this helps
Anne Tro
Author: Dreamboat on Wor
Email: Dreamboat*at*Piersontech.co
Web: www.TheOfficeExperts.com
 
Could you post the SQL of one of your queries? It could be something as simple
as changing the query join from an INNER JOIN to a LEFT JOIN or a RIGHT JOIN.

If you open up your query in the design grid, you can double click on the join
line between the tables and select show all your staff table and show matching
in the linked table.
 
Back
Top