Prev: how to handle meter readings
Next: command button not opening related fields
From: Jimbo on 11 Nov 2009 09:54
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.
From: Pecoflyer on 11 Nov 2009 11:51

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. :)


--
Pecoflyer

Cheers -

Firefox 3.5.3 is as slow as possible !
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/showthread.php?t=153089

[url="http://www.thecodecage.com"]Microsoft Office Help[/url]

From: John W. Vinson on 11 Nov 2009 17:02
On Wed, 11 Nov 2009 16:51:41 +0000, Pecoflyer
<Pecoflyer.41hx8s(a)thecodecage.com> 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]
From: Daryl S on 16 Nov 2009 11:07
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.
> .
>
 | 
Pages: 1
Prev: how to handle meter readings
Next: command button not opening related fields