sort question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
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
 
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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IPhone sound quality gets worse each generation 5
sort fields in table 2
Sorting 3
AI Tech Support - BETA feature 8
How to create a sort order number in a query 2
Changing Sum Range Based on Date Chosen from Drop Down List 1
Distinct Count in Crosstab 1
Formula to report dates in a new tab 2

Back
Top