grouping and sorting (1 Viewer)

[flect]

I have a database with a primary feature of sorting/categorising products based on the input text into a totally insane but explicit order on reports.

The reports are sorting and grouping as required - what I'm trying to do now is essentially copy the exact same multi-tiered grouping and sorting that I'm using on the report in a query so that the appropriate sort order can be used in other forms.

Basically - the sorting is happening on the report - I want it to happen in the query.

The group, sort, and total settings on the report are:
1: Sort by CountrySortOrder - smallest to largest
2: Group on Stampcountry - with A on top
3: Sort by StampGroupOrder - smallest to largest
4: Sort by StampDescription - with A on top, by first 13 characters
5: Sort by Categorygrouporder - smallest to largest

is there a way to put all this into the query? or will i have to somehow stack query on top of other queries?

any ideas?!

 

[wazz]

general comment: grouping and sorting is typically a left-to-right affair. so the order of the fields in the query grid is important. if you want to sort by field 'a' before field 'b' put them in the grid in that order. if you want to see them in a different order, put field 'a' in the grid twice: 'a' (sorted; do not show) - 'b' (show) - 'a' (again; show). hth.

 

[flect]

Thanks Wazz - Left to right is doing what I need it to do!

Cheers!