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. |
|
|
Thread Tools | Display Modes |
|
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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 | |
|
|