| | |
|
|
|
sorting primary key properly |
|---|
| message from Kevin on 27 May 2004 |
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?
|
| Van T. Dinh replied to Kevin on 26 May 2004 |
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)
to sort its pk
number, and not
|
| Brian Kastel replied to Kevin on 27 May 2004 |
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]).
|
|
Archived message: sorting primary key properly (MS Access Database)
