AVG Function

[klr397]

Probably simple....

I am using the avg function in a query to calculate the average risk score of all employees. But when i do it my quesry looks like this

Joe shmoe 2.345
Joe shmoe average 2.345
jane doe 2.567
jane doe avg 2.567

how do i make it say only one of those lines. I dont care which i just want it tohave one line per employee.

Thanks

 

[Ziggy1]

don't use the function click the totals button on tool bar or on the View menu. You will then see "Group by" in the query design grid. the field that you are trying to get the average for chnge from group by to AVERAGE.

also look at your data you may have included too many fields in the design which is causing it not to Group to the single record. Eg...

if you are looking for the average of the Month but are including the Full Date then you won't get an accurate average, you would want to change the date to display a Month.