a-z

[ron fynn]

i have table that are sorted to a-z the data has codes in
them ,one row with a code i use a lot i would like to
keep this row at the top, is there any way i could this
and keep the rest sorted a-z

ron

 

[Rick Brandt]

i have table that are sorted to a-z the data has codes in
them ,one row with a code i use a lot i would like to
keep this row at the top, is there any way i could this
and keep the rest sorted a-z

Sort on an expression using the Immediate-If IIf() function. You can give it a
test that is true only for that one row and return a string of "aaaa" and for
the false return your normal field value.

 

[Van T. Dinh]

Just in case you don't know, Rick is talking about creating a Query to view
your data since you can specify / create custom sort / order in Queries.

 

[Rick Brandt]

Well, the Advanced Filter tool will let you do this with a table as well, but I
would certainly recommend a query instead.