Sorting & Orderby

[Guest]

Hi
I've got a table/query of data, which has: Year Group & Student. I have
grouped the students by Year Group, but I want the groups of data to appear
in a specific order on the report.

ie. F, L5, U5, L6, U6

but am getting F, L5, L6, U5, U6 without having to index the year groups as
a number, can I specifically state how I want the Orderby parameter to
process the data?

Thanks

 

[jahoobob via AccessMonster.com]

Create a table of the Year groups with a number associated with each Year
group e.g F 1, L5 2, etc.
Join the original table to this table in a query by Year group and put the
order numbers from the second table in the query and sort by that.

 

[Van T. Dinh]

It is probably incorrect to store [Year Group] as a single Field. It seems
to me that the Field store 2 different items of data (one for Year and one
for Group).

If that the case, suggest you split this into 2 separate Fields in your
Table which will facilitate simple sorting and grouping.