Calculating by an expression and another field

A

Alaska1

I have created an expression in Access to figure out the amount of hours it
takes for a person to complete a work packet. Using the below formula

Expr1: DateDiff("h",[OrderDateClerk],[CompletedandReturnedDate])-16*DateDiff
("d",[OrderDateClerk],[CompletedandReturnedDate])


I need to group by the person who compeleted the packets and total the
amount of work order they completed by summing up the work order field and
then divide by the number calculated above.

I need to make sure the number of hours from the equation above are grouped
and then the total work order package so I can divide them and get a total.
i need to put the information in a graph. it is to show productivity.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculating time in Access based on an 8 hour day 2
Display weeks from a Milestone 0
Trying to create custom labels from an csv file + Need items numerically counted out 0
IIF in Crosstab Expression 0
Help with an IIF expression 2
Calculating time difference using working days and working times 6
Totaling Times 2
"Compile error in table level validation expression " after format 0

Top