I get a error message anytime I try to create a pivot table in access. The message is not enough memory to create pivot table. I have tryed just limited items and still get this message. My PC has 4 gig of ram, so this should not be a problem. Any ideas?
-
-
Access can be "picky" with pivot tables.
I often use as a workaround a temp table holding the basic queries data and base the pivot table as "straight forward" as possible on this temp table.
Nic;o) -
need more detail on walk around table. This is not very clear. What can cause errors in ms access when making pivot tables.Comment
-
The walk around is to change the select query used for the pivot table a create table query.
Then a straight forward "Select" from this temp table can be used for the pivot query.
For the cause you'll have to ask Microsoft, as I haven't been able to find it.
Nic;o)Comment
Comment