ASP.NET, SQL Server, WPF, C#, VB.NET

Hello, 
 
I've created a query that list all Access Reports that were written for 
 
various departments. The query works fine but is displaying duplicate 
 
department names (one display for each Access Report written for that 
 
department). 
 
I'd like to display the results (w/o duplicate department names) in an 
 
Access Report as follows: 
 
DEPARTMENT  NUMBER OF REPORTS WRITTEN 
 
HR                  10 
 
Payroll             21 
 
Accounting       35 
 
Please advise and thank you in advance, 
 
Bob

Base your report on a Query.  In design view of the query, choose View, 
 
Totals. 
 
GroupBy Department, Count Reports. 
 
-- 
 
Joan Wild 
 
Microsoft Access MVP 
 
SkyGuy wrote: