sort question

S

surya

Hi (newbie question)
Is there a simple way to fool a field into sorting the way I want, example:

13
13-SE-C
14
341
963

(The 13-SE-C is going to the bottom)
 
A

Arvin Meyer [MVP]

You will need to either add a sort column with either text or numeric
content, or you can write some sorting code. You can also use code in a
column to grab the numeric beginning like:

Expr1: Val([YourField])

It will return a 0 if the field starts with any letter though.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access
 
S

surya

Thank you, I appreciate the help.
--
Cheers


Arvin Meyer said:
You will need to either add a sort column with either text or numeric
content, or you can write some sorting code. You can also use code in a
column to grab the numeric beginning like:

Expr1: Val([YourField])

It will return a 0 if the field starts with any letter though.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

surya said:
Hi (newbie question)
Is there a simple way to fool a field into sorting the way I want, example:

13
13-SE-C
14
341
963

(The 13-SE-C is going to the bottom)
Click to expand...
Click to expand...
 
Top