View Single Post
  #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.
.