How do I count total numbers of a classification?

[Michael Knauf]

I'm working on a staff database... each staff member is assigned a department (via a drop down list field) and a shift that they work (1,2,3 or 4) I want to make a layout that will list each department and the total number in each shift... Iv'e tried varius ways of defining calculation fields (sum, count) and I'm just not getting it to work...

Michael

[transpower]

Have a separate record for each shift (which are are in a file separate from members). Have a summary count field for each shift in the member file. Then put that field on the shift layout. If you have the two files properly related, you will get the correct count.