Cross tab problem

[scubadiver]

I have a select query that I want to turn into a cross tab. The value I want
to use is the average hours for the row and column heading (week and
department).

The error I get is "Invalid precision for decimal data type".

What is going on?

 

[Duane Hookom]

How about providing your SQL view as well as your field data types.