Re: Assistance needed in getting the correct sort order
The recordset is presented as a text SQL string that includes an ORDER BY so the problem has to be something about the recordset itself.
As an experiment, can you define a (named & stored) query that is defined using the same SQL string you used for that recordset? You can go into SQL design view and copy/paste that string to do so. Then open it as a SELECT query and see what it returns. That is the starting point for troubleshooting. If it returns what you expected, see if you can then update the record through that query.
When you did that substitution of "*" for "TOP 1 " did you already have a stored query to do that or did you just cobble together some SQL?
And I have a question that suddenly slammed me: To what does the ![avlto] refer in this line:
![avlto] = rsemp![avlto]
By that I mean, is there a form in place and open with a control named ![Avlto]? Because if that is the case, then the WITH syntax gets more confused. You would still need that WITH because of the .Edit and .Update operations. But those other items in that sequence might have fooled me. Can you elucidate?
I'm a certified grandpa (3 times now) and proud of it.
Retired over one year and survived being home all day with the wife. She must really love me.
If I have helped you, please either click the thanks or click the scales.