Group tables in a pivot

[Thyag]

Hi All,

I need to group multiple tables in to a pivot.

Could some body help me.

Thanks in Advance,
Thyag

[Larry Linson]

"Thyag" <th**************@gmail.comwrote

I need to group multiple tables in to a pivot.

Could some body help me.

Probably, no, nobody can help you unless you explain in some detail what it
is you are trying to accomplish. What you've stated is so vague as to not
be helpful at all... except that you want to use a pivot-table approach.

Larry Linson
Microsoft Access MVP

[Thyag]

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

[Larry Linson]

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