Sorting A to Z across a row?

  • Thread starter Thread starter Mike375
  • Start date Start date
M

Mike375

Guest
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 number default field.

Mike
 
1. Access is a relational database. It is not a spreadsheet. Relational databases do not provide functions that operate on repeating groups. Therefore the answer is you're on your own. Since your structure violates first normal form, you will need to create your own functions.
2. You can create a calculated column in a query that uses the Rnd() function and sort on that. Be sure to seed the randomizer first or you'll keep generating the same set of numbers.
 
Pat Hartman said:
1. Access is a relational database. It is not a spreadsheet. Relational databases do not provide functions that operate on repeating groups. Therefore the answer is you're on your own. Since your structure violates first normal form, you will need to create your own functions.
2. You can create a calculated column in a query that uses the Rnd() function and sort on that. Be sure to seed the randomizer first or you'll keep generating the same set of numbers.

How do you seed the randomizer first?
 
If you look up the Rnd() function in help (make sure you have a VBA window open before asking for help), it tells you how.
 

Users who are viewing this thread

Back
Top Bottom