sorting primary key properly

  • Thread starter Thread starter Kevin
  • Start date Start date
K

Kevin

Must be simple, but can I please know how to set Access to sort its pk
in a human way, recognizing all the characters in the pk number, and not
sorting just on the first character?
 
A numeric PK sorts numerically. If your field is a text field containing,
say, "1" through "10," then it would sort like this: 1, 10, 2, 3, 4, ... Is
this what is happening? If so, just change your field to a numeric field,
or use a query that sorts on Val([YourPKField]).

--

Brian Kastel


--Original Message----------------

Must be simple, but can I please know how to set Access to sort its pk
in a human way, recognizing all the characters in the pk number, and not
sorting just on the first character?
 
Suggest you post a sample of 5-10 PK values and how they
should be after the required sort.

HTH
Van T. Dinh
MVP (Access)
 
Back
Top