Sorting & Orderby

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Wendy - 27 Apr 2006 16:13 GMT

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

Reply to this Message

jahoobob - 27 Apr 2006 16:31 GMT

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.

>Hi
>I've got a table/query of data, which has: Year Group & Student. I have
[quoted text clipped - 8 lines]
>
>Thanks

Reply to this Message

Van T. Dinh - 28 Apr 2006 08:00 GMT

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.

Signature

HTH
Van T. Dinh
MVP (Access)

> Hi
> I've got a table/query of data, which has: Year Group & Student. I have
[quoted text clipped - 10 lines]
>
> Thanks

Reply to this Message