How to Sort Arrays in MS Access VBA Using Insertion Sort

[@mohammedelfaramawi3028]

Great Sean. Thank you for the wonderful informative video. I have one question , if you apply this loop to a field (column) in a table, what will happen when ties are present?

[@seanmackenziedataengineering]

Great question! I have not tested it, but I reviewed it, and this implementation of Insertion Sort should retain the original order when ties are present. This means it is a "stable" algorithm.

[@mohammedelfaramawi3028]

Thank you very much. I will test it

[@claudiorodriguez3315]

Hi Sean, thank you so much for sharing this solution. It has been really helpul for me. Cheers

[@seanmackenziedataengineering]

Great to hear!

[@interestingamerican3100]

This content dude.....blown away by this channel! OMF Gawd!!!

[@seanmackenziedataengineering]

Awesome!