Help with pivot table

[Jimbo]

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.

 

[Pecoflyer]

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 !

 

[John W. Vinson]

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.

 

[Daryl S]

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.