Sum Results

[cityanangelstx2004]

I am trying to create a query that will permit me to total the results for projclass, nocust, skillset and svc for each month. I have a table which consist of the following:

accesstablesum.xls
	A	B	C	D	E	F	G
1	projectid	year	month	projclass	nocust	skillset	svclvlagree
2	10151	2004	November	10	2	0	0
3	10233	2004	November	10	3	0	0
4	10235	2004	November	10	3	0	0
5	10238	2004	November	15	3	1	0
6	10255	2004	November	15	3	0	0
7	10289	2004	November	15	3	0	1
8	10299	2004	November	25	3	0	1
9	10331	2004	November	15	1	0	0
10	10338	2004	November	10	3	0	0
11	10348	2004	November	25	3	0	1
12	10350	2004	November	15	3	0	1
13	10372	2004	November	25	3	0	0
14	10684	2004	December	10	1	0	0
15	10693	2004	December	10	3	0	0
16	10662	2004	December	10	1	0	0
17	10716	2004	December	15	3	0	0
18	10385	2004	December	15	3	0	0
19	10720	2004	December	10	3	0	1
20	10681	2004	December	10	1	0	0
21	10572	2004	December	10	2	0	1
22	10685	2004	December	10	1	0	0
projects

I am not sure what would be the most simplistic approach. Any help is greatly appreciated. Thanks in advance.

 

[Norie]

Is this a table in Access?

If so just create a totals query based on the table. Group by month and sum/count other fields as appropriate.

 

[cityanangelstx2004]

Yes it is in Access. I originally couldn't get the query to work before I posted my question, but, based on your response I realized I had added one to many fields to my query and then the end result was not working. I have corrected the problem and it is now working properly. Thank you for your help.