Hi Experts,
I am struggling to get a maximum date.
I have 3 x tables. Table 1 is the Client, table 2 is Equipment, table 3 is Assessment.
I have these linked by RefNo to table Client. I have no link from Equipment to Assessment.
I want a list of all clients and their equipment, which I can get. However I also want to know when they where last Assessed. They could have had more than 1 assessment and I only want to know the most recent Assessment.
When I try this by grouping table 1 by Refno, then go Report>Selection Formulas>Group and use:
maximum({tblAssessmentV8.DateAssessed}) = {tblAssessmentV8.DateAssessed}
It just gives me the highest in the whole table.
Any help would be appreciated.
Many Thanks