averages query

[hlacroix]

Hi,

In my database, I have clients and client hours. I need to calculate average client hours. My total client hours expression is: TTotals: Sum((Nz([SessionHoursCompleted])+Nz([OptionalHoursCompleted]))). I need to divide this number by the number of clients.
Any suggestions ie sum of client number, sum of clients, count of clients.
I've tried these and the results are incorrect.

Thank You

 

[CraigDolphin]

Create a query (qryCients) like

Select ClientID from YourTable Group By ClientID;

Then try

TTotals: Sum((Nz([SessionHoursCompleted])+Nz([OptionalHoursCompleted])))/DCount("ClientID","qryClients")