At the risk of being redundant, can anyone help me out on how to sort an Access table using VB6 and ADO connection. I'm hoping there's a one line of code to do it instead of looping through all the records. Thanks in advance!