Getting Records in Numerical Order

J

J

I have a report which displays my data in the format of:

1
10
11
12
13
2
20
21
22
23

I need it to be able to be in numerical order like this:

1
2
3
4
5
etc.

What do I need to do in order to accomplish this?
 
R

Rick Brandt

J said:
I have a report which displays my data in the format of:

1
10
11
12
13
2
20
21
22
23

I need it to be able to be in numerical order like this:

1
2
3
4
5
etc.

What do I need to do in order to accomplish this?
Click to expand...

Either change the underlying field's DataType from Text to Number or sort on the
expression...

SortVal: Val([FieldName])
 
Top