Hi
I would like my pivot table to draw data from several tables in an Access
database. Although I have gone through the query wizard and added the fields
from all the database tables, I still find that when Excel reads the data
into the pivot table it stops after the first table and I only get part of
the source data I am looking for.

What am I missing in order to consolidate the data from several tables?

with thanks.