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?
2018-06-19 01_12_02-Microsoft Access - Database1 _ Database (Access 2007).jpg
Reply With Quote