Sorting numbers with text datatype

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jayceejay - 04 May 2005 22:09 GMT

I am really FRUSTRATED and I hope someone can shed some light. I am using
digits of my own choosing for "CUSTNUM" field -- the primary key for this
table. I assigned a text data type to the field, as I do not intend to
perform any math on the entries in this field. When I go to sort on this
field, shouldn't the records STILL SORT in ascending order 1-25...or however
many numbers I have? I cannot get my records to sort from smallest CUSTNUM
to largest. What gives?

Reply to this Message

Ofer - 04 May 2005 22:08 GMT

If you want to sort your text box as number you will have to convert it to
number using clng, text box sort diferently by the order of the first digit
and then the scond one etc, so if you have for example
1,2,5,7,9,11,15,23,54,55,66,211
it will sort it that way
first the 1
1,11,15 then the two 2,211,23 then 5,54,55 then 66, 7 ,9

> I am really FRUSTRATED and I hope someone can shed some light. I am using
> digits of my own choosing for "CUSTNUM" field -- the primary key for this
[quoted text clipped - 3 lines]
> many numbers I have? I cannot get my records to sort from smallest CUSTNUM
> to largest. What gives?

Reply to this Message

Marisol - 12 May 2005 06:27 GMT

How can I create a table in Access with specific criteria?
For example, I need to create a table from 0 to 9 fields. I need to know
what can I do to have a number that finish in 1 to 9 go to the specific column

Signature

Thanks for your help,

Marisol

Reply to this Message

Rick B - 12 May 2005 15:01 GMT

Huh? What are you trying to accomplish? This sounds very odd and I would
bet that you are not using the best design for your data. There are many
sorting and grouping options that can be used in your forms, queries, and
reports. VERY RARELY should you need to make a new table and move data to
it.

What are you trying to accomplish?

Signature

Rick B

> How can I create a table in Access with specific criteria?
> For example, I need to create a table from 0 to 9 fields. I need to know
> what can I do to have a number that finish in 1 to 9 go to the specific column

Reply to this Message

Marisol - 14 May 2005 19:54 GMT

Good Afternoon Rick

Let me give you an example:
I work with wholesale lottery tickets. Usually I enter all the tickets
number in a table, but I need to have a template or I dont know what that
whenever I enter a new number, this one need to be sort into a column for the
last number. I dont know if I know how to explain this correctly in English.

Signature

Thanks for your help,

Marisol

> Huh? What are you trying to accomplish? This sounds very odd and I would
> bet that you are not using the best design for your data. There are many
[quoted text clipped - 8 lines]
> > what can I do to have a number that finish in 1 to 9 go to the specific
> column

Reply to this Message