For the report to be meaningful, those tables will have to be related, so
you should create a query, joining the tables, and extracting the pertinent
fields, and create your pivot table or pivot chart from that query. For
data in a "grid" as produced by a pivot table to be usable, you'll need to
limit the amount of data displayed at each "intersection" -- a huge grid
with a lot of data shown for each intersection soon becomes unusable by mere
human beings.
Larry Linson
Microsoft Access MVP
"Thyag" <th**************@gmail.comwrote in message
news:f0**********************************@j20g2000 hsi.googlegroups.com...
Hi Larry,
Example -
I have a database of four or five tables.
I know how to create a foru pivot table from four individual
tables...but my problem here is i need to combine all the four or five
tables in to a single pivot table.
IS THIS POSSIBLE, if so please let me know how can it be dome.
Please reply for more detailed explanation.
Thanks,
Thyag