Pivotcharts

P

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

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
 
P

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 :(
 
Top