468,538 Members | 1,812 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,538 developers. It's quick & easy.

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
Jan 11 '08 #1
3 2282
"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
Jan 11 '08 #2
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
Jan 11 '08 #3
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

Jan 11 '08 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Prasad Patil | last post: by
reply views Thread by Rami | last post: by
3 posts views Thread by nikila | last post: by
reply views Thread by Thyag | last post: by
reply views Thread by NPC403 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.