I need to know how many different documents of a certain type an employee has entered

[goakley]

Hi,
We enter different types of documents. They have standards that we have to meet based on the type of document. The different types of documents are distinguished by "program" names. I have a table that has the date, the program (many different programs are done in one day), the number of documents entered on that program, the time it took to enter those documents, how many documents were reviewed, and how many errors were found. One employee will have several entries, one day will have several programs.



employee name
Date
program
volume
EntryTime
reviews
errors

One of the totals I need is the number of different programs this employee has done. I grouped on "employee name" and chose "count" under program. But the query returns the number of records. The database has 74 entries, but the employee has only done about 10 different programs.

[orange]

After reading your post it seems that you may not have a database structure that suits your business. You mention documents but there is nothing defined as Document? Or Document type?? Who does the Reviews?
Date is a reserved word in Access.
If you are just starting with this database, it might be a good time to get it structured to support your Business.

Can you describe to us in clear, plain English WHAT your Business is? We only know what you tell us, so keep it simple. Until readers are familiar with your set up, they can not provide focused comments/advice.

[June7]

Do query that selects distinct program for each employee. Can be a GROUP BY or use DISTINCT qualifier.

Then use that query to build another query that counts the records.

The two queries can be combined with nesting. Review http://allenbrowne.com/subquery-01.html#Aggregation