My headaches come in the form of sums. I am trying to build an overview of military duty sections to see what duty section has what amount of people in it based off of rank.
I have queries that divide up and show who is E1 to E4 assigned to Duty Section 1, and another for E5 to E6 assigned to Duty Section 1. I have that set up for all 8 duty sections.
My table has these fields; Last, First, Rank, School, Indoc, Phone, Address, Section Assigned, NMT, PAC, Chapel, Restricted
I have been racking my brain here and need help in the best way to have something to show how many E1 - E4 are in section 1, how many E5 and E6 are in section 1, repeated for all the sections and displayed in one snapshot so I can decide which section needs people without going to each report to see who has what number of personnel.
Any suggestions on this? I was trying to do a query to add up how many unique records were in each section then show it on a report for easy viewing.
I just cannot figure out how to do this because I get all sorts of mismatch blah blah errors when trying to use sum and count. I can't figure out how to sum a aggregate count field in a query. I'm just at wit's end trying to solve this and no amount of searching has yielded an answer yet.
Thanks