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
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