Query cannot be procssed

G

Gert

Hi all

I have a weird problem.

I made a web page with a Pivot table on it. I have an Access 2000
database which contains the table which is my data source. When I
select fields from the list of fields as detail fields, everything
goes fine. When I select a field as filter field, it goes well too as
long as I select everything. As soon as I make a selection within this
filter I get the error message: Cannot process this query, no further
details are given. I also get this error message when I select a field
as row field or column field.

So in the detail fields part of the pivot table, it all goes well. But
when a field is used as row, column of filter field it goes wrong. And
it does not tell why.

I excluded some possible causes:
- export to Excel goes well. There filtering and all is possible
- it also happens when I have a SQL Sevrer table as data source so it
is not Access


Can anyone help me??


regards, Gert
-
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

QBF & Query Malfunction 0
Dealing with a Pivot Table (when I don't want to) 0
Slicers and Calculated Items in Pivot Table 2
Unable to display values in 2nd list box from 1st list box selection 2
Excel does not accept text format! 0
Mail Merge query 1
Page numbering with Merged Document and IF statements 1
Insert Index into a Table 1

Top