October 14, 200421 yr 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
October 14, 200421 yr 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.
Create an account or sign in to comment