A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Help with pivot table



 
 
Thread Tools Display Modes
  #1  
Old November 11th, 2009, 03:54 PM posted to microsoft.public.access.tablesdbdesign
Jimbo[_2_]
external usenet poster
 
Posts: 17
Default Help with pivot table

I want to know how many employees I have working in a given half hour
with the state licensure they have.

I have a table that has my employees, state licensure and each
individual half hour segement they are working. When I view as a
pivot table, the results are giving me all that have that specific
state licensure.

Example: @ 6am, I have one person with Alaska licensure, but the pivot
table say 11 (that is my total staff with Alaska)


How do I make this happen? Thanks in advance.
Ads
  #2  
Old November 11th, 2009, 11:02 PM posted to microsoft.public.access.tablesdbdesign
John W. Vinson
external usenet poster
 
Posts: 18,261
Default Help with pivot table

On Wed, 11 Nov 2009 16:51:41 +0000, Pecoflyer
wrote:

HOW TO GET FURTHER HELP WITH A WORKBOOK
For further help with it why not join our forums (shown in
the link below) it's completely free, if you do join* you will have the
opportunity to add attachments to your posts so you can add workbooks to
better illustrate your problems and get help directly with them*. Also
if you do join please post in this thread (link found below) so that
people who have been following or helping with this query can continue
to do so.


Or you can use any newsreader (Outlook Express, Windows Mail, Agent, or any of
hundreds of other free or fee programs) and connect to msnews.microsoft.com to
get the help of hundreds of volunteers, and avoid the limitations of a forum
which nags you to pay for a VIP membership, loads slowly, limits the number of
responders, and just slurps posts posted on the FREE, OPEN newsgroups and
claims credit for them.
--

John W. Vinson [MVP]
  #3  
Old November 16th, 2009, 05:07 PM posted to microsoft.public.access.tablesdbdesign
Daryl S[_2_]
external usenet poster
 
Posts: 881
Default Help with pivot table

Jimbo -

If this is Excel, please use the Excel forum. If this is a crosstab query
(which is similar to a pivot) in Access, then just make sure your criteria
includes the holf-hour segment you are interested in, or use that as your
column headers.

If this doesn't work, you will need to give us more information on your data
structure so we can help you more.

--
Daryl S


"Jimbo" wrote:

I want to know how many employees I have working in a given half hour
with the state licensure they have.

I have a table that has my employees, state licensure and each
individual half hour segement they are working. When I view as a
pivot table, the results are giving me all that have that specific
state licensure.

Example: @ 6am, I have one person with Alaska licensure, but the pivot
table say 11 (that is my total staff with Alaska)


How do I make this happen? Thanks in advance.
.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 08:29 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 OfficeFrustration.
The comments are property of their posters.