Department Incomplete Work Order query

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hi
I have a table that has a list of departments (tblDept)(15 entries). I
want to count the number of incomplete work orders in the 15 depatrtments in
tblDept from another table tblNewMwo (2500 entries). The tblNewMwo has a
column called Dept and it has entries that are the same as the table [tblDept.
Dept] , but some of the entries do not match the entries in the table
[tblDept.Dept] . The criteria for incomplete is an empty entry in [tblNewMwo.
Date_Complete]. I would like to end up with the 15 departments and the number
of incomplete work orders for each department in the list.

--
Danny C. Sperry

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/200706/1

.