Pivotcharts

[Pwyd]

Is there a simple way to use two seperate tables on the same pivotchart?
They have a relationship linked by their autonumber fields (unique). What
i'd like to accomplish is creating a simple bar graph, showing the totals of
some items on each table as a part of the entire grand total, on each bar.
I'm unsure how to accomplish this. Having read through the helpfiles
available, i could only find references for showing multiple plots from the
same dataset. Any help?

 

[Tom van Stiphout]

On Tue, 16 Sep 2008 05:21:01 -0700, Pwyd

Create a query joining the two tables. Then base the pivotchart on
that query.

-Tom.
Microsoft Access MVP

 

[Pwyd]

I've done that. It doesn't allow me to use a filter that applies to both
tables in the filter fields. when i drop it in, it throws away one of the
tables