By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,940 Members | 611 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,940 IT Pros & Developers. It's quick & easy.

Group tables in a pivot

P: n/a
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
Share this Question
Share on Google+
3 Replies


P: n/a
"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

P: n/a
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

P: n/a
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.