Search results

Hi all, can someone help me with this please? I need to remove any duplicates from Query: qu_combined_sp which have the highest Rank (highlighted). The result I need is in Query: qu_combined_sp_result Thanks for your time!! Regards... Nick

Hi all, I use Access sporadically to produce reports from our ERP package which is limited to say the least. Although I've been using Access for what seems like ever I sometimes don't have to start it up for 6 months at a time! That means I need to jog my (getting older by the moment) memory...