 |
|
 |
|
Next: PPT 2008 (for Mac) Viewing on PPT (for Win) - cop..
|
| Author |
Message |
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 |
|
 |  |
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 |
|
 |  |
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 |
|
 |  |
| 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 |
|
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
|
|
|
|
 |
|
|