Group query by date

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
Hi Donna - Give this a try. In your report layout go to Sorting and Grouping
and enter =[date of hire]+60 and =[date of hire] + 240 and =[date of hire]
+ 360. As long as it is a valid expression it should give you your groupings -
Yours Dika (KG)
 
Back
Top