A Group query “not sorted†option doesn’t work. Any suggestions?

L

LenJr

A Group query “not sorted†option doesn’t work. Any suggestions?
If you have table with the following records:

FLD
2
2
1
1
3
3

and create a group query that is unsorted you would expect:
2
1
3

To be returned.
But in fact (at least for me)
1
2
3
Is being returned.
 
J

John Spencer

When Access GROUPs items it sorts them and then groups them, it also does
this when you use Distinct to return only unique values. So the items
remain in that sorted order which was used for grouping.

Unless you specify a Sort Order, Access returns the records in any order it
wishes to.
 
J

John Spencer

No way to do it? No there is always a way. You would need to add a column
to your table that tells Access the sort order of the fields.

Why does 2 come before 1 which comes before 3? If you had
2
2
1
1
2
3
3
1
2

and scrambled them, how would you know that the order should be 2,1,3?
 
Top