Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Use SQL to sort mixed data 1
- Thread starter JOD59
- Start date
-
1
- #2
For the field that contains the values you wish to sort
apply the Val function in another field.
In my case I used the values you provided in my table.
1170
60
1745/1160/870/570
850
1730
3600
3600
3
3500
5
In the query I simply added a field and applied the Val function to the field that contained the data and had the query sort in ascending order.
The result -
Data Number <- This field is defined as
3 3 Number:Val([Data])
5 5
60 60
850 850
1170 1170
1745/1160/870/570 1745
3500 3500
3600 3600
3600 3600
apply the Val function in another field.
In my case I used the values you provided in my table.
1170
60
1745/1160/870/570
850
1730
3600
3600
3
3500
5
In the query I simply added a field and applied the Val function to the field that contained the data and had the query sort in ascending order.
The result -
Data Number <- This field is defined as
3 3 Number:Val([Data])
5 5
60 60
850 850
1170 1170
1745/1160/870/570 1745
3500 3500
3600 3600
3600 3600
- Status
Similar threads
- Locked
- Question
- Locked
- Question
