Originally Posted by June7 Correction, in Access 2010 it showed the same formula in each cell but doesn't seem to work. Here is method for older versions. Get a list of unique values in Excel & extract unique rows (ablebits.com) This fix is so much better, thank you
Last edited by Aussiebear; 11-28-2023 at 12:50 AM. Reason: Removed the spam link
Forum Rules