Re: New to Forum - Need some help pls
You can do the following in the SQL view of a new query
SELECT [Data-Billing].[Employee Number], [Employee Cost centre], Count([Data-Billing].[Employee Number]) as NumberofCCs
GROUP BY [Data-Billing].[Employee Number], [Employee Cost centre]
If you want to do this using the design grid view of the query, add the data-billing table and the two fields. Then add the employee number field a second time. Right click on this column in the grid and select Totals. When you select Totals, a new row shows up in the grid called Totals. In the totals row, change Group By to Count for this third column. The first two fields should stay as Group By
Last edited by jzwp22; 02-04-2013 at 11:36 AM.