J
julostarr
In my database I am trying to sort my companies part numbers. They contain
both letters and number, for example 22D10-2, 21BC123, 25TD47, 38WS101 or
21D10 are some of the part numbers. In my products list table they sort in
the correct order, which is first by number then by letter then by number
again, but I created a query, which I'm using for a report on our Booked
Sales for the year, and I want to sort it first by the month then by the part
number. Everything sorts fine except for a group of a few part numbers which
should be further down in the list. These mis-sorted numbers are sorted
correctly within the little group, but they are not sorted correctly within
the entire list of part numbers. A part number like 25TD47 is in between
part number 21D10-2 and 21FA101. This doesn't make since to me.
Can anyone help me out with fixing this problem?
both letters and number, for example 22D10-2, 21BC123, 25TD47, 38WS101 or
21D10 are some of the part numbers. In my products list table they sort in
the correct order, which is first by number then by letter then by number
again, but I created a query, which I'm using for a report on our Booked
Sales for the year, and I want to sort it first by the month then by the part
number. Everything sorts fine except for a group of a few part numbers which
should be further down in the list. These mis-sorted numbers are sorted
correctly within the little group, but they are not sorted correctly within
the entire list of part numbers. A part number like 25TD47 is in between
part number 21D10-2 and 21FA101. This doesn't make since to me.
Can anyone help me out with fixing this problem?