Sorting numbers with text datatype

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

Guest

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?
 
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
 
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?
 
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.
 
Back
Top