MyCode when "only Active" is selected:
Expand|Select|Wrap|Line Numbers
- Me.RecordSource = "SELECT Projects.* FROM _
- (Projects INNER JOIN LastStatusDates ON _
- Projects.ProjectID = LastStatusDates.ProjectID)INNER JOIN StatusReports _
- ON (Projects.ProjectID = StatusReports.ProjectID) AND _
- (LastStatusDates.Last_Status_Date = StatusReports.StatusDate) _
- WHERE (((StatusReports.Status)='active')) _
- ORDER BY Projects.ProjectID"
The later query contains a "Max" function on the date.
This code, written by someone else, did work, but apparently I've messed it up. I tried adding "Me.OrderByOn = True" ahead of this code, but no luck...
I hope I was clear. Any help would be awesome.
Thanks in advance