Ordering data in a field, in table view A,B,C...0,1,2,3

I

Ian B

I have data in a field, as part of an Access Table. I wish to order the data
A, B, C, ..... then 0, 1 2, 3,...... (Using A-Z puts the numbers first.)
I have used an additional field to sort the data but this is not suitable as
I am restricted by the fields I can use.
Any ideas?
 
D

Douglas J. Steele

Why are you restricted by the fields you can use? You can add as many
computed fields as you want in a query, and sort by them. If you add a field
IsNumeric([YourSortField]), it will return True (-1) for the numbers and
False (0) for the letters. Sort by that field (descending) before your sort
field (ascending)
 
I

Ian B

Douglas

The table is exported to another software package as a fixed width text file
which dictates the number of fields, the field lengths and the total number
of characters. I have added fields which sort my data, similiar to how you
describe, but I have to remove them from the table before I export. As soon
as the "sort" field is removed the table re-orders itself.

regards

Ian B

Douglas J. Steele said:
Why are you restricted by the fields you can use? You can add as many
computed fields as you want in a query, and sort by them. If you add a field
IsNumeric([YourSortField]), it will return True (-1) for the numbers and
False (0) for the letters. Sort by that field (descending) before your sort
field (ascending)

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)



Ian B said:
I have data in a field, as part of an Access Table. I wish to order the
data
A, B, C, ..... then 0, 1 2, 3,...... (Using A-Z puts the numbers first.)
I have used an additional field to sort the data but this is not suitable
as
I am restricted by the fields I can use.
Any ideas?
Click to expand...
Click to expand...
 
R

Rick Brandt

Ian said:
Douglas

The table is exported to another software package as a fixed width
text file which dictates the number of fields, the field lengths and
the total number of characters. I have added fields which sort my
data, similiar to how you describe, but I have to remove them from
the table before I export. As soon as the "sort" field is removed the
table re-orders itself.
Click to expand...

Export a query instead of a table. A query can sort on fields that are not
included in its output.
 
Top