grouping data from acces

[wmbb]

Is it possible to generate a asp-page retrieving data from a acces database with grouping;
I have data like this...

funktion: sectionleader
name: john
group: all

funktion: groupleader
name: peter
group: group 1

funktion: groupleader
name: peter
group: group 2

funktion: groupleader
name: peter
group: group 3

funktion: groupleader
name: jim
group: group 4

funktion: groupleader
name: jim
group: group 5

is it possible to generate a list like:

sectionleader (john)

groupleader (peter)
group 1
group 2
group 3

groupleader (jim)
group 4
group 5

 

[Lilliabeth]

That doesn't look like database tables, but regardless, you should do the grouping in an Access query and then send the results to FrontPage.

 

[wmbb]

The data is the result of a query.
I just put it in this way to show the data.

It is possible to group the data in acces but how do I get the groups grouped by the sectionleader without specifying the sectionleader in frontpage.