Zazvata
06-18-2018, 03:06 PM
Hello! Access newbie would appreciate any help with following issue. I have database with table as shown in picture. Column N contains repeating values, each must be counted for how many times each appears in database. If count is >=10, then appropriate 3rd largest value from column P should be found, e.g. for 100288414 it is 10.3432543886119. Then corresponding values from N, W and P copied and pasted into another table. And so on until the end of database. How can I do it in Access?
22449
22449