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