Crosstab Query Error "Property Not Found"

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

The Mecca - 04 Nov 2005 22:12 GMT

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?

Reply to this Message

Duane Hookom - 04 Nov 2005 22:53 GMT

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.

Signature

Duane Hookom
MS Access MVP
--

> I'm not sure what I am doing wrong. I have a crosstab query, nothing
> fancy,
[quoted text clipped - 9 lines]
> 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?

Reply to this Message

The Mecca - 04 Nov 2005 23:50 GMT

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;

> 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?
[quoted text clipped - 16 lines]
> > 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?

Reply to this Message

Duane Hookom - 05 Nov 2005 05:35 GMT

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"?

Signature

Duane Hookom
MS Access MVP

> There are no calculations except for the sum, but it is an easy
> calculation.
[quoted text clipped - 36 lines]
>> > down the side. I can not figure out an easy way to do this.
>> > Suggestions?

Reply to this Message

The Mecca - 07 Nov 2005 18:36 GMT

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?

> 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"?
[quoted text clipped - 39 lines]
> >> > down the side. I can not figure out an easy way to do this.
> >> > Suggestions?

Reply to this Message

Duane Hookom - 08 Nov 2005 01:52 GMT

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?

Signature

Duane Hookom
MS Access MVP
--

>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
[quoted text clipped - 49 lines]
>> >> > down the side. I can not figure out an easy way to do this.
>> >> > Suggestions?

Reply to this Message