Hi folks
I'm having a problem using the MAX calculation. I have one table linked to another via URN and I just want to select the max value in the linked table by the max (or latest) date. So, if on 18/2/11 I have a record with an N (in the approved field) but on the 23/2/11 I then have a Y in the...