Moving records within a table

I have a simple question.

I want to move records within a table to predetermine the sequence that show up on the table/query on the form.

For example, I want to move the record “orange” in front of the record “apple”, see the table below. No matter what I try, I cannot move records around within a table.

Apples
Bananas
Oranges

Have you tried using a decsending sort?

Alternatively you could add an additional column with numbers that you manually enter to get a desired sort order.

Descending and ascending sort will not get the records in an unaphabetical order.

But your suggestion about adding an additional column of number, placing numbers by the record in the order I want and then sorting by the additional column order will work.

Thanks.

Sorry for not coming back here...I actually lost where this forum was.