I have a table that lists Name, Rank, SSN, Command, Date Member Received Preseparation Counseling, and Date of Member's separation. I must create a query giving me the following information: Total number of Service members receiving pre-separation counseling:
(1) 24 months before separation
(2) 12 months before separation
(3) 90 days or more to separations
(4) 89 days or less to separation
(5) percent with 90 days or more