I really need some help very badly. I have posted this problem before and have used the info people have suggested to me but have been unsuccessful in making it work. I have even went through the PHP array and sort libraries but was unable to get it to work.
I haven't ever used an array before. I have been told it is even more difficult when using Access.
I have a form which my users input up to 6 dates into 6 text boxes. I have created an array "Dim BDate(1 To 6) As Date" in Access. I have a SwapDate Sub where I need to take the dates placed into the array and sort them from oldest to earliest but am unable to get it to work. Can anyone help me create a For/Next loop to go through the dates in my array to sort and then re-arrange them in the correct order. Your help would be greatly appreciated. 🙂