hello.
i am trying to sort a recordset but it is not working:
Set rst = db.OpenRecordset(strSQL)
rst.Sort = "CountOftPrimaryCrop Ascending" 'ASC has same effect
rst.MoveFirst
Do Until rst.EOF
Debug.Print rst.Fields("CountOftPrimaryCrop")
rst.MoveNext
immediate window:
7
1
1
i tried sort descending, immediate window:
7
1
1
what could be wrong?
i am trying to sort a recordset but it is not working:
Set rst = db.OpenRecordset(strSQL)
rst.Sort = "CountOftPrimaryCrop Ascending" 'ASC has same effect
rst.MoveFirst
Do Until rst.EOF
Debug.Print rst.Fields("CountOftPrimaryCrop")
rst.MoveNext
immediate window:
7
1
1
i tried sort descending, immediate window:
7
1
1
what could be wrong?