Crosstab Query Error "Property Not Found"

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm not sure what I am doing wrong. I have a crosstab query, nothing fancy,
but I keep getting an "overflow" or "property not found" error. I can't find
the error in the help files, nor does it give me any explaination of the
error. Has anyone else had this error?

A little background. I have a report I am trying to create for all of our
call center agents. There are 250 of them, and each of them has 12 months
worth of data. For months Jan - Dec, I need 10 pieces of information.

I need for each report to have the months across the top, and the columns
down the side. I can not figure out an easy way to do this. Suggestions?
 
You might be dividing by zero or something somewhere. Does the query run by
itself? If not, what is the SQL view of your crosstab?

What type of calculations are you doing in your report? If the query works,
save a copy of your report and start removing controls one at a time until
the errors go away.
 
There are no calculations except for the sum, but it is an easy calculation.
in the query. The query it is based upon works just fine.

Here is the SQL to the crosstab:

TRANSFORM Sum(query01.avg_hold_time) AS SumOfavg_hold_time
SELECT query01.acd_id, query01.empl_id, query01.fullname
FROM query01
GROUP BY query01.acd_id, query01.empl_id, query01.fullname
PIVOT query01.work_date1;
 
What happens when you follow my other advice "save a copy of your report and
start removing controls one at a time until the errors go away"?
 
I guess I am not certain of what you are referring to. It is not a report,
but a query. and since it is a crosstab- how can I remove anything without it
not working?
 
Were you just kidding us when you stated "I have a report I am trying to
create" and "I need for each report to have the months across the top"? That
sounds like a report.

Are you stating the query is giving you the error message and not the
report?
 
Back
Top