need assistance - novice access database

[mzm2779]

i have created an access database to track the amount of work that comes in,
is processed and completed in one week, for my staff.

I am now attempting to create reports and run querires to gain the following
data:
turn around time from receipt to entry per tech per week and per month
number of contracts approved per week
number of contracts pending per week

i have the following main table:
Agent code
Last Name
First Name
Middle Name
Individual
Corportation
Corporation Name
contracting Specialist
Contract Received
Contract Entered
Date of Decision
Decision

So, i know that i need to create an expression... but have no idea where to
start...
could really use some help.

Thank you,
Michelle

 

[KARL DEWEY]

I suggest using two tables, one for employees and another to record work.
tblEmployee --
EmpID - Autonumber - primary key
Last Name
First Name
Middle Name
etc.

Work --
WorkID - - Autonumber - primary key
EmpID - Long integer - foreign key
Agent code
Individual
Corportation
Corporation Name
contracting Specialist
Contract Received - I assume this is start
Contract Entered
Date of Decision - I assume this is finish
Decision

--turn around time from receipt to entry per tech per week and per month
SELECT [First Name], [Middle Name], [Last Name], Avg(DateDiff("d", [Date of
Decision], [Contract Received])+1) AS Average_Turn_Around
FROM tblEmployee LEFT JOIN WORK ON tblEmployee.EmpID = WORK.EmpID
WHERE [Date of Decision] Between DateAdd("d", -6,Date()-Weekday(Date())) AND
Date()-Weekday(Date())
GROUP BY [First Name], [Middle Name], [Last Name];

- number of contracts approved per week
SELECT [First Name], [Middle Name], [Last Name], Count([Date of Decision] AS
Comp_Last_Week
FROM tblEmployee LEFT JOIN WORK ON tblEmployee.EmpID = WORK.EmpID
WHERE [Date of Decision] Between DateAdd("d", -6,Date()-Weekday(Date())) AND
Date()-Weekday(Date())
GROUP BY [First Name], [Middle Name], [Last Name];

- number of contracts pending per week
SELECT [First Name], [Middle Name], [Last Name], Count([Contract Received]
AS Comp_Last_Week
FROM tblEmployee LEFT JOIN WORK ON tblEmployee.EmpID = WORK.EmpID
WHERE [Date of Decision] Is Null
GROUP BY [First Name], [Middle Name], [Last Name];