a-z

  • Thread starter Thread starter ron fynn
  • Start date Start date
R

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
 
ron fynn said:
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
Click to expand...

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.
 
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.
 
Well, the Advanced Filter tool will let you do this with a table as well, but I
would certainly recommend a query instead.
 
Back
Top