MS Access: dictionary sorting and manipulation

Question

Suppose I want to have a list of item as below

arr["john"] = 40
arr["mark"] = 12
arr["clark"] = 53
arr["sam"] = 23

Now I want to sort them depending on the values as below

arr["clark"] = 53
arr["john"] = 40
arr["sam"] = 23
arr["mark"] = 12

How can I do this?

There is not a lot of difference between VBA and VBScript http://stackoverflow.com/questions/268648/how-do-i-sort-arrays-using-vbscript — Fionnuala, Jul 08 '15 at 22:31

score 0 · Answer 1 · edited May 23 '17 at 12:00

0

You could use a Dictionary from the Microsoft Scripting Runtime library:

edited May 23 '17 at 12:00

Community

answered Jul 09 '15 at 16:58

Gustav

1 Answers1