Trying to total hours by code worked

teresamichele

Registered User.
Local time
Today, 00:19
Joined
Oct 18, 2010
Messages
13
I have a database in Access 2007 that I can upload our time entry data into.

Each project has a "code" and the primary key is actually 3 fields - the employee ID, the fiscal month, and that code.

I created a query to view the hours worked by code...but it shows each individual entry. So if 3 people put time in October under the code for Safety - Safety shows up 3 times. I want it to show up once, and under "Hours Worked" I want the total of those 3 entries.

Is there a way to run a query that will give me each project code and the TOTAL for the code, rather than each individual entry? :)

Thanks!

Teresa
 
Have you tried a totals query? With the query in design view, click on the "E" on the ribbon/toolbar that says totals. You want to group by your code field and sum the hours field.
 
HA! I had googled it and it said something like that, but I was on the "Home" tab - where there is a Totals option - but it's not active in design view. I knew if you suggested it, it was right, though, so I kept clicking and found it. Thanks a ton! :)
 

Users who are viewing this thread

Back
Top Bottom