as said
get all this into an array variable
and using following function you can determine whether they are in ascending order.
This function will return true if array is in ascending order.
hope this will help you
(07-31-2009, 10:23 AM)venkatbatchu Wrote: Note: I could able to retrieve all the fields in to variables here main issue is how to validate that all fields are in ascending order
get all this into an array variable
and using following function you can determine whether they are in ascending order.
Code:
Function IsAscending(sArray)
'Assign default value of IsAscending
IsAscending = true
For i= 0 to UBound(sArray) - 1
If sArray(i) > sArray(i+1) Then
'Return value of IsAscending
IsAscending = false
exit for
End If
Next
End FunctionThis function will return true if array is in ascending order.
hope this will help you

