Hi there - I'm a bit lost at the moment and am new to this. Please help!
I have two different categories that an employee's work needs to be filed under, which for simplicity we will call A and B - the case they were working on and the type of work they were doing. For example, they worked on case A doing a type of work, B. I know which employee did the work and how much that employee is paid. So what I want to build is a query that will tell me, per month, how many hours employees worked on case A doing B, as well as a second query that will tell me how much money we spent as a firm working on case A doing B.
Does this make sense? As in, how many hours did Bob and John collectively spend doing procurement ("B") for case A? And how much did it cost us for Bob and John to do procurement for case A?
I have a table with the employees and their pay rates as well as a table of tasks with hours spent on them and case numbers. The queries I have tried to run using all of this information have either not functioned or not done what I want. I'm not sure where to go from here, but know this is an obvious enough task that there must be a way to do it properly. Please help! :banghead:
I have two different categories that an employee's work needs to be filed under, which for simplicity we will call A and B - the case they were working on and the type of work they were doing. For example, they worked on case A doing a type of work, B. I know which employee did the work and how much that employee is paid. So what I want to build is a query that will tell me, per month, how many hours employees worked on case A doing B, as well as a second query that will tell me how much money we spent as a firm working on case A doing B.
Does this make sense? As in, how many hours did Bob and John collectively spend doing procurement ("B") for case A? And how much did it cost us for Bob and John to do procurement for case A?
I have a table with the employees and their pay rates as well as a table of tasks with hours spent on them and case numbers. The queries I have tried to run using all of this information have either not functioned or not done what I want. I'm not sure where to go from here, but know this is an obvious enough task that there must be a way to do it properly. Please help! :banghead:
