HELP with CrossTab Query

[betheball]

I have 4 fields in my table, Employee, InputDate, Volume, and Hours. I want to display the Employees down the left column, the InputDate across the top and then Volume divided by Hours in the middle. I tried this:

TRANSFORM (Closures.[10Volume]/Closures.[10Hours]) AS AvgOf10Volume
SELECT Closures.IDRS
FROM Closures
GROUP BY Closures.IDRS, Closures.[10Volume]/Closures.[10Hours]
PIVOT Format([InputDate],"Short Date");

But that is giving me multiple instances of each employee name with a lot of empty cells. Thoughts?

 

[betheball]

I had to put that in there because without it I get:

"You tried to execute a query that does not include the specified expression
'Closures.[10Volume]/Closures.[10Hours]' as part of an aggregate function"

 

[betheball]

Thanks Pat.