Hi, how would I create a report like this one? It looks to me like a pivot table's the way to go, but how would I feed it? There are 1041 records so it would be great to either find a formula for the database or one to create a calculated field in the table.
TIA,
Jandy
MrXL BBS que.xls | |||||||
---|---|---|---|---|---|---|---|
A | B | C | D | E | |||
1 | Dummy Data | ||||||
2 | Employee ID | Dept | DOH | TermDt | RehireDt | ||
3 | 434 | Charlie | 29-Apr-77 | ||||
4 | 50 | Alpha | 3-Jan-05 | 5-Oct-05 | |||
5 | 51 | Alpha | 1-Mar-66 | ||||
6 | 260 | Echo | 3-Sep-04 | 2-Nov-04 | |||
7 | 221 | Alpha | 15-Jun-04 | 14-Aug-04 | 8-Sep-04 | ||
8 | |||||||
9 | Sample Report (doesn't correspond to dummy data) | ||||||
10 | Department | Date | Active Employees | Terminations | |||
11 | Alpha | 30-Apr-04 | 2 | 0 | |||
12 | 31-May-04 | 2 | 0 | ||||
13 | 30-Jun-04 | 3 | 0 | ||||
14 | Bravo | 30-Apr-04 | 2 | 1 | |||
15 | 31-May-04 | 1 | 0 | ||||
16 | 30-Jun-04 | 1 | 0 | ||||
17 | Charlie | 30-Apr-04 | 1 | 0 | |||
18 | 31-May-04 | 1 | 0 | ||||
19 | 30-Jun-04 | 1 | 0 | ||||
Samples |
TIA,
Jandy