Query Expression help

[Guest]

What is the correct expression to get average handle time per return, rather
than per batch (returns are logged in batches that vary in quantity).
Currently using this espression to get AHT per batch- Handle Time: [Sign In
Time]-[Sign Out Time]
I would like to divide this sum by [Processed], which is already an
expression Processed: [Filed]+[Sent to Accounting]+[Pended] to ger AHT per
return.
I tried- Handle Time: sum([Sign In Time]-[Sign Out Time])/[Processed], but
that doesn't work.
Help!

 

[John Spencer]

Perhaps the following, although I suspect that will not give you the results
you expect.

SUM([Sign In Time]-[Sign Out Time]) / ([Filed]+[Sent to
Accounting]+[Pended])



--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[Guest]

I get the following error:
You tried to execute a query that does not include the specified expression
'Sign Out Time' as part of the aggregate function.

Perhaps the following, although I suspect that will not give you the results
you expect.

SUM([Sign In Time]-[Sign Out Time]) / ([Filed]+[Sent to
Accounting]+[Pended])



--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

What is the correct expression to get average handle time per return,
rather
than per batch (returns are logged in batches that vary in quantity).
Currently using this espression to get AHT per batch- Handle Time: [Sign
In
Time]-[Sign Out Time]
I would like to divide this sum by [Processed], which is already an
expression Processed: [Filed]+[Sent to Accounting]+[Pended] to ger AHT per
return.
I tried- Handle Time: sum([Sign In Time]-[Sign Out Time])/[Processed], but
that doesn't work.
Help!

 

[John Spencer]

That would seem to mean that you have referenced Sign Out Time somewhere
else in the query without assigning an aggregate function such as Sum, Avg,
First, etc to the field.

I suspect that you have little idea of how to build an aggregate query and
that this is causing you problems.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

I get the following error:
You tried to execute a query that does not include the specified
expression
'Sign Out Time' as part of the aggregate function.

Perhaps the following, although I suspect that will not give you the
results
you expect.

SUM([Sign In Time]-[Sign Out Time]) / ([Filed]+[Sent to
Accounting]+[Pended])



--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

What is the correct expression to get average handle time per return,
rather
than per batch (returns are logged in batches that vary in quantity).
Currently using this espression to get AHT per batch- Handle Time:
[Sign
In
Time]-[Sign Out Time]
I would like to divide this sum by [Processed], which is already an
expression Processed: [Filed]+[Sent to Accounting]+[Pended] to ger AHT
per
return.
I tried- Handle Time: sum([Sign In Time]-[Sign Out Time])/[Processed],
but
that doesn't work.
Help!