Help with Grouping data

  • Hi All

    Following is my table structure with the data. I just cant work out the query to group the data by Rank & Board. I would like to generate 2 queries to do the grouping based on Rank & Board.

    Please find attached the table structure and the layout of report.

    I would really appreciate any help or pointers on creating this 2 report.

    regards

    Mitesh

  • I can't see that what you need is more than this:

    --Report 1

    select Rank, Name, Board

    from MyTable

    sort by Rank, Name, Board

    --Report 2

    select Board, Name, Rank

    from MyTable

    sort by Board, Name, Rank

    ______________________________________________________________________________
    How I want a drink, alcoholic of course, after the heavy lectures involving quantum mechanics.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply