Search results

OK, so have tested that approach. On the positive side it worked with the correct output including rankings after running the query on a table. On the negative side it still took a long while - about 2hrs 15mins with the table having approx 85K records and approx 8.5K 'groups' within that...

Thanks Brian, Will have a go at that using a macro ... think VBA may be a bit beyond my capabilities! Regards, Jacko

Hi there, By way of intro I'm no expert but have managed to look at this and other forums to try to find a way to achieve what I need to (in Access 2007). Essentially I'm trying to rank rows based on values (x) for each value of another field (y). So the outcome will be an order ranking by...