I have a record select formula where it searches for the halfterm in a table, currently i just have a number in there but I want to change it so that it'll bring through the data for the highest halfterm value it can find.
So i tried using a maximum function to bring through this number but i got an error message saying 'This function cannot be used as it must be evaluated later'.
I now know the reason why it cant do this but i'm wondering if anyone knows how i can look for the max half term and bring through the data for that row.
IP Logged