Does anyone know of any function or method in Access to sort across a row?

I can do it and have it in my data base for 10 fields. However, it was lengthy to make and I might have to make another version of it, which will take quite some time.

Also, is there any way to apply a random sort to a column. Presently I have to append a table backwards and forwards with a randon numbedr default field.

Mike