G
Guest
I have a query that calcluates from the hire date 2month, 6 month, 1 year
evaluation using the Date Add. Could I create a report the lumps these
columns under their due dates? I can group under the Employee but not under
the individual column. The following is the tables I'm basing this on
EmpID
EmpLast
EmpFirst
DateOfHire
Qry
EmpID
EmpLast
EmpFirst
2 month Eval: (DateOfHire) + 60
6 month Eval: (DateOfHire) + 240
1 Year Eval: (DateOfHire) + 365
evaluation using the Date Add. Could I create a report the lumps these
columns under their due dates? I can group under the Employee but not under
the individual column. The following is the tables I'm basing this on
EmpID
EmpLast
EmpFirst
DateOfHire
Qry
EmpID
EmpLast
EmpFirst
2 month Eval: (DateOfHire) + 60
6 month Eval: (DateOfHire) + 240
1 Year Eval: (DateOfHire) + 365