Skip to Content
0
Jan 26, 2023 at 02:03 PM

Maximum Date

30 Views

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