Subject: Total Queries, Showing Values that Have No Count		View Full Headers List Thread in New Window List Thread in Group Window List Thread in Article Window
From: <larryh@appliedimage.com>
Date: 14 Feb 2001 21:58:42 GMT
Message-ID: <96ev2i$dug$1@news.netmar.com>
Newsgroups: microsoft.public.access.queries

I have a totals query which joins 2 tables, PROJECTS and MANAGERS. Each
project has a manager assigned to it, and they are linked by a "project
manager" field in the PROJECTS table, which matches the "autoid" number in
the MANAGERS table.

I have a query which counts how many projects are assigned to each manager.
The count is accurate, the only thing is that I wish for some way to make the
query show those managers who don't have any projects assigned to them. The
query ignores those with a zero count.

Any fix for this?

Larry

From: ggrandon@aol.com (Gordon Grandon)

Larry, bring the MANAGERS table and the PROJECTS  table into the grid. Link
them on autoid. Right click the join line and select join properties. Select
option 2 ( All from managers and only those from projects that match).
Select the fields from the managers table you want to see and also select
the autoid field from the PROJECTS table. In the PROJECTS.autoid field enter
the criteria of Is Null.  I didn't know if you would want this in the same
query so I gave you directions for a separate query, you can use the same
logic, I think, in your original query if you want it that way. HTH

 -----  Posted via NewsOne.Net: Free (anonymous) Usenet News via the Web  -----
  http://newsone.net/ -- Free reading and anonymous posting to 60,000+ groups
   NewsOne.Net prohibits users from posting spam.  If this or other posts
made through NewsOne.Net violate posting guidelines, email abuse@newsone.net