Group tables in a pivot

Hi All,

I need to group multiple tables in to a pivot.

Could some body help me.



Thanks in Advance,
Thyag

Re: Group tables in a pivot

"Thyag" wrote

> 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

Re: Group tables in a pivot

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

Re: Group tables in a pivot

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" wrote in message
news:f079a5cc-c110-4b56-93f6-61c84706c386@j20g2000hsi.google groups.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