automatic sorting of fields

[mikarsen]

Is there a code or command than can automatically scan/sort all the fields on the table without manually entering the individual fields in the code.

example i have three fields
field1, field2, field3

the code i am presently using is a series of IF THEN statements for each field.I have to write the individual field names.

I want to know if its possible for access to automatically test each field in the table.

Many thanks.

 

[gemma-the-husky]

open the table, make the columns cotiguous, grab the headers and sort ...

or ... extract a query, and sort the key columns in the sort criteria section

 

[Pat Hartman]

Sounds like a spreadsheet function to me. Access is a relational database. It is not a spreadsheet. There are no functions that take all the fields in a record and sort them. In fact there are no functions at all that work "accross" a table's columns, nor will there ever be. Do some reading on normilzation to understand proper table design. Hopefully you will come to understand that you need to create "three" rows rather than columns to store this data.