Pivot Table will not show any data - Query cannot be processed

G

Guest

Hi, I am using an MS Access Project front end with a SQL Server db and I have
a very useful Pivot Chart, but my Pivot Table just won't show any data, It
keeps saying that the query cannot be processed. Press F9 to restart the
query and display data. This doen't do anything though.

My only thoughts are data types? But why is this different to the Pivot Chart?

Are there any rules to consider with Data structures / relationships? I am
only using one 'View' from SQL with fields such as Date / transaction details
/ customer.

Any ideas? Any help wil be much appreciated.

Thank you, Lawrence.
 
G

Guest

Hi, I found the answer to my own problem! If anyone else is interested all
you need to do is refresh the data by going to Datasheet view and then back
to the Pivot Table view.

Thanks, Lawrence
 

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

Access 2003 pivot table subform 0
Pivot table view does not show series data with decimals? 0
Cannot create pivot table 1
Excel Excel Pivot Chart/Pivot Table query 0
The query could not be processed: Error opening data file 2
my access pivot table says the query cannot be processed. 1
Access query not showing as sources for pivot table 2
Grouping dates in pivot table 3

Top