Pivot Table

[Steve]

A query returns seven properties for a list of products: Property1,
Property2, Property3, etc. The properties are assigned to each product by a
combobox for each property on a form. I would like to create a Pivot Table
that displays the products across the top and the seven properties down the
left side. It would look like:
ProductA ProductB ProductC etc
Property1
Property2
Property3
etc

How do I get the seven properties to list vertically? When I drop multiple
properties in the Row drop zone, they line up horizontally rather than
vertically. I don't want the Pivot Table reversed where the products are at
the left and the properties are across the top.

Thanks!

Steve

 

[Duane Hookom]

What is your table structure and what is the current SQL view of your
crosstab that doesn't work?

 

[Steve]

Thanks for responding, Duane!

It's not a crosstab query, it's a Pivot Table.

The data table looks like:
TblProduct
ProductID
ProductName
Material
Color
Finish
etc

The query is based on TblProduct and sorts the ProductNames alphabetically.

I need the Pivot table to look like:
ProductA ProductB ProductC etc
Material
Color
Finish
etc

Steve

 

[Duane Hookom]

I don't do pivot tables in Access as I find crosstab queries have as much
functionality as I require. If this solution is for a report, you might want
to check the crosstab reports at
http://www.invisibleinc.com/divFiles.cfm?divDivID=4

 

[PCD]

You ought to look at Pivot Tables; they have much more functionality than
Pivot Tables.

Steve

 

[Keith Wilby]

Alias "PCD" <[email protected]>

You don't seriously expect any help from anyone on here do you PC D?

 

[John Marshall, MVP]

You ought to look at Pivot Tables; they have much more functionality than
Pivot Tables.

Steve

Wow, such insight. By not mentioning your 1000+ followers, was that suppoed
to be a joke?

John... Visio MVP

 

['69 Camaro]

Hi, Keith.

You don't seriously expect any help from anyone on here do you PC D?

If history is any guide, then Steve, just like anyone else, can always
expect help from many of the Access experts. Not only are the Access
experts extremely talented, but they're also extremely generous, too.
Whenever Steve posts questions as either PC Datasheet or Steve (so that
everyone knows who's asking the question), he usually gets very good answers
from the experts.

However, questions on Pivot Tables may be an exception, because most of the
database experts use other reporting tools for drill downs, drillups, and
slicing and dicing data, so there may not be that many experts hanging
around this newsgroup familiar with Pivot Tables to provide Steve with the
help he needs.

----------------------------

To Steve: If you don't get help from an expert familiar with Pivot Tables,
then you have an excellent opportunity in front of you. Figure out the
problem and write a tip describing how you solved it, and then post the tip
on your Web site. Then whenever you see others asking questions about Pivot
Tables that are similar to your problem here, you can post a link to the
"Pivot Tables" tips page of your Web site. In addition, you could post many
of your own Access and Excel tips on your Web site that you feel would help
others, and then provide a link to those tips in your sig line. If you
write high quality, helpful tips, you'll find others in the newsgroups
gladly posting links to your Web site's tips, too, when they're helping
posters with their questions, thereby increasing your visitor traffic and
potential customers.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.

 

['69 Camaro]

Hi, John.

I realize that you're trying to set a good example for those of us who
aren't very good at put-downs and only have the book, "1001 Put-Downs For
Every Occasion" to guide us, but Steve clearly made a typo in his post. He
provided an excellent opportunity for you to kid him about making sure that
the coffee pot was on before starting work, but by giving him a put-down
instead, you only made yourself look uncharitable.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.

 

[Keith Wilby]

Hi Gunny ...

Hi, Keith.


If history is any guide, then Steve, just like anyone else, can always
expect help from many of the Access experts. Not only are the Access
experts extremely talented, but they're also extremely generous, too.

Yes they are talented and generous but also human beings which I imagine
don't take kindly to all the name-calling which PCD frequently resorts to.
This could explain the lack of response to the OP and I wonder if Duane knew
with whom he was dealing when he responded.

Whenever Steve posts questions as either PC Datasheet or Steve (so that
everyone knows who's asking the question), he usually gets very good
answers from the experts.

His need to hide behind an alias to ask a question speaks volumes IMO. Why
not ask the question as "PC D(atasheet)"?

To Steve: <snip> and then post the tip on your Web site. Then whenever
you see others asking questions about Pivot Tables that are similar to
your problem here, you can post a link to the "Pivot Tables" tips page of
your Web site. In addition, you could post many of your own Access and
Excel tips on your Web site that you feel would help others, and then
provide a link to those tips in your sig line. If you write high quality,
helpful tips, you'll find others in the newsgroups gladly posting links to
your Web site's tips, too, when they're helping posters with their
questions, thereby increasing your visitor traffic and potential
customers.

HTH.
Gunny

That is indeed excellent advice. It's a shame that it will almost certainly
be ignored.

Regards,
Keith.

 

[John Marshall, MVP]

Gunny, you have been around these newsgroups to be aware of steve's
reputation. He has a history of posting incorrect information, answering
without fully reading the question and personal insults. So it was hard to
determine whether it was a typo, or just another attempt to get his self
promotion in the newsgroup.Considering steve's past behaviour, I chose the
later. So yes, I was being selectively uncharitable.

John... Visio MVP

 

[Duane Hookom]

I use pivot tables regularly in Excel and never in Access.

 

[Duane Hookom]

I didn't realize I was answering PCD but don't think it would have made a
difference in my response. I am too forgiving at times.

 

['69 Camaro]

Hi, Keith.

Yes they are talented and generous but also human beings which I imagine
don't take kindly to all the name-calling which PCD frequently resorts to.

I agree, and the result is that some of them have kill filed him, but
certainly not all of them, because they still reply to his posts.

This could explain the lack of response to the OP

Agreed, but in this case, I think a lot of it has to do with the topic, as
well. Access Pivot Tables aren't in common usage, so people aren't racing
to answer Pivot Table questions here like they are with subforms,
Before_Update( ) events, MDE's, et cetera. For previous questions on other
topics he's posted when he identified himself as either PC Datasheet or
Steve, he's usually received good, helpful answers.

His need to hide behind an alias to ask a question speaks volumes IMO.

Volumes the size of mountains. Wait a minute . . . you aren't taking a stab
at _my_ alias, are you? I know to stay on my toes when you're around.
Those zingers of yours hit their targets spot on! ;-)

Why not ask the question as "PC D(atasheet)"?

Perhaps he's posting as Steve so that he can have a few moments of peace
while trying to get the help he needs, without having to deal with those who
are dogging his heals in the other threads where he's advertising as PC
Datasheet. Personally, I think if he takes the bull's-eye off his chest,
people won't be shooting at him wherever he goes.

That is indeed excellent advice. It's a shame that it will almost
certainly be ignored.

It takes effort, time and some degree of skill, but you know as well as I do
that it's a successful strategy. A fortunate side effect is that by working
at this strategy, one can develop a reputation over time as an authority in
specific areas, or even on a general topic, so it's well worth pursuing,
even if there isn't a monetary reward.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.

 

['69 Camaro]

Hi, John.

Gunny, you have been around these newsgroups to be aware of steve's
reputation.

Steve has worked very hard to earn his reputation, as have the rest of us.

He has a history of posting incorrect information, answering without fully
reading the question

Access has a steep learning curve. Not even the Access experts know
everything there is to know about Access, so one cannot reasonably expect
any poster to provide the right answer every single time. People make
mistakes. I don't know how you handle this phenomenon in the Visio
newsgroups, but in the Access newsgroups, it's customary to post a polite
response to set the poster straight and provide the correct answer, or a
link to the correct answer. When this tactic has been used on Steve, I've
seen him respond, "Thanks! I didn't know that."

If my Gramma told me once, she told me 4,036,587 times, "You get further
with honey than you do with vinegar." I'll pass that on to you, since she
was way too busy reminding me so she never had time to offer this advice to
anyone else, and I don't want you to be without it any longer.

So it was hard to determine whether it was a typo, or just another attempt
to get his self promotion in the newsgroup.

When you're in the middle of a heated argument, it's difficult to see the
other side's point of view. If you step back a moment and re-read the posts
in this thread, you'll find that Steve behaved himself and never attempted
self-promotion. You'll also find that so far there are three participants
in this thread who can be said to be attempting some degree of
self-promotion: two MVP's and me, the biggest self-promoter in this thread,
because I've even included a link to a Web page with my contact information.

So with that revelation, am I to expect to have to show up to endure your
public floggings, too? Or am I to understand that it's not the act of
self-promotion that is condemned, but the person instead? John, you and
several others have tried in earnest to discourage Steve, ostensibly to curb
Steve's behavior. However, in this thread Steve complied with your
expectations that he not advertise and not post under a bogus identity --
and still he got smacked.

John, stay your hand. You're giving the impression that it's an MVP's job
to smack people around.

And that's just not right.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.

 

[John Marshall, MVP]

For most people a polite correction would be enough, but steve has thumbed
his nose to the regulars and indicated that only he could provide the
correct answer. So since he insinuates he is above the regulars he needs to
be held to the standards he implies he has.

You'll also find that so far there are three participants in this thread
who can be said to be attempting some degree of self-promotion: two MVP's
and me, the biggest self-promoter in this thread, because I've even
included a link to a Web page with my contact information.

I have no issue with self promotion, as long as it at the end of a useful
post. In the Visio newsgroups, my sigline includes a link to my webpages
that have additional free Visio information. Since it is not relevant to
Access, I drop the link. The only thing I could even midly complain about
with your posts is the level of importance you some times put on marking
answers as important.

The main steve posts that I tag are the ones where he indicates that the
user should contact him for more help. This takes the thread off line and
anyone
following the question runs into a dead end rather than an answer.

John, stay your hand. You're giving the impression that it's an MVP's job
to smack people around.

That is definitely not the job of the MVPs, they are here to provide
guidance. Occasionally they may need to remind some of the users
about ettiquete. Part of the issue with solicitations is that it can get out
of hand, so people like steve need to be reminded.

Smack is probably a strong word for what I posted. It was more like a nudge.
I have tried to be polite towards steve and not sink to the level of
personal slurs that he has thrown at me and others that have commented on
his behaviour.

John... Visio MVP

 

[Keith Wilby]

Hi again Gunny ...

message

Volumes the size of mountains. Wait a minute . . . you aren't taking a
stab at _my_ alias, are you? I know to stay on my toes when you're
around. Those zingers of yours hit their targets spot on! ;-)

You flatter me sir, I'm not that clever! As far as I can remember you've
always used the '69 Camaro alias, but then my memory doesn't always serve me
well

It takes effort, time and some degree of skill, but you know as well as I
do that it's a successful strategy. A fortunate side effect is that by
working at this strategy, one can develop a reputation over time as an
authority in specific areas, or even on a general topic, so it's well
worth pursuing, even if there isn't a monetary reward.

Absolutely.

Regards,
Keith.