Welcome to Windows Help!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

I'm cryin' here -- please help with pivot tables

 
   Windows Help (Home) -> Microsoft Access RSS
Next:  PPT 2008 (for Mac) Viewing on PPT (for Win) - cop..  
Author Message
JoLeigh

External


Since: Apr 8, 2009
Posts: 2



(Msg. 1) Posted: Thu Sep 24, 2009 12:05 pm
Post subject: I'm cryin' here -- please help with pivot tables
Archived from groups: microsoft>public>access (more info?)

I posted the following message yesterday, but got no responses. I'm an
infrequent Access user, but I've become so dependent on this group for help
when I get stuck. Can anyone give me a little insight? Thanks so much!!!
JoLeigh

I've been creating pivot tables in Access 2000 but just upgraded to Access
2003 and can't seem to get on board.
As a simple example to get me started, suppose that I want to count the
number of occurences for a given event for each day of the week. With 2000,
I would drag the Day of Week field to the left hand margin and would select
"Count" for Day of Week and drag it to the center of the table. How would I
do this in 2003?
Thanks so much,
JoLeigh

 >> Stay informed about: I'm cryin' here -- please help with pivot tables 
Back to top
Login to vote
Frank H

External


Since: Sep 21, 2009
Posts: 2



(Msg. 2) Posted: Fri Sep 25, 2009 8:16 am
Post subject: RE: I'm cryin' here -- please help with pivot tables
Archived from groups: per prev. post (more info?)

Just in case you haven't yet figured this out...
Haven't used them for a while; I see what you mean.

When you drag the field to the row area, it makes the groups just fine?
But then when you drag the same field to the data area, it removes it from
the row area?
If you are wanting a count, try this: Drag the desired field to the row
area, then drag the primary key field (or some other field you can count on
to contain a value in each desired record) to the data area. This will list
all of the details; but you want a summary.
Then you have to right click on the field name in the data area, and use
that menu to select a calculation. Lastly, you right click again to Hide
Details.

Post back as to whether that works for you!

 >> Stay informed about: I'm cryin' here -- please help with pivot tables 
Back to top
Login to vote
JoLeigh

External


Since: Apr 8, 2009
Posts: 2



(Msg. 3) Posted: Mon Sep 28, 2009 12:45 pm
Post subject: RE: I'm cryin' here -- please help with pivot tables
Archived from groups: per prev. post (more info?)

Frank,
Took a little holiday from pivot tables --
You saved the day! This works.
Thanks so much.
JoLeigh

"Frank H" wrote:

> Just in case you haven't yet figured this out...
> Haven't used them for a while; I see what you mean.
>
> When you drag the field to the row area, it makes the groups just fine?
> But then when you drag the same field to the data area, it removes it from
> the row area?
> If you are wanting a count, try this: Drag the desired field to the row
> area, then drag the primary key field (or some other field you can count on
> to contain a value in each desired record) to the data area. This will list
> all of the details; but you want a summary.
> Then you have to right click on the field name in the data area, and use
> that menu to select a calculation. Lastly, you right click again to Hide
> Details.
>
> Post back as to whether that works for you!
> --
> Frank H
> Rockford, IL
>
>
> "JoLeigh" wrote:
>
> > I posted the following message yesterday, but got no responses. I'm an
> > infrequent Access user, but I've become so dependent on this group for help
> > when I get stuck. Can anyone give me a little insight? Thanks so much!!!
> > JoLeigh
> >
> > I've been creating pivot tables in Access 2000 but just upgraded to Access
> > 2003 and can't seem to get on board.
> > As a simple example to get me started, suppose that I want to count the
> > number of occurences for a given event for each day of the week. With 2000,
> > I would drag the Day of Week field to the left hand margin and would select
> > "Count" for Day of Week and drag it to the center of the table. How would I
> > do this in 2003?
> > Thanks so much,
> > JoLeigh
> >
 >> Stay informed about: I'm cryin' here -- please help with pivot tables 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Tables Disappeared - Access2003 on XPproSP2. All of the tables and queries in my database have suddenly disappeared, but the forms can still see the data. I've tried closing and repairing, I've tried importing into a new database - the forms and reports can be imported bu...

Query from 3 tables - I have three tables that I want to put in query. But this is what I need: Articles Stores MinimumQTY ----------- ---------- --------------------- ArticleID StoreID ArticleID..

Simultaneously create records in multiple tables - I'm creating a project database for my company in access. We use a specific Project Number for each of our projects (i.e. 09-01-100). Each project has so much information that I actually used all the fields in my first table! It has expanded to four..

swap tables when more than one table is linked to primary .. - I am using office 2007 and have linked a few tables to my primary master table, and is working fine. Only problem is, that now I need to swap back to a previious table that is still linked to the primary table, and i cant seem to find any where on my...

Microsoft Office - Can you update Microsoft office version 2003 to 2007 or do you have to buy the newer version
   Windows Help (Home) -> Microsoft Access All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]