Displaying relational data

[GreenBottle]

Hi,

I'm really having a difficult time with this, please help.
I have a query that returns all records that I need, but since I can not use the rs.moveprevious (like the old days) I'm just beating my head against the wall trying to figure this one out.

I have 2 database tables and use an inner join in my query for speed
What I get back from query is this:

Name........LastName..........InNum........OutNum
Cabin 1........Jones..............191............199
Cabin 1........Smith..............203............205
Cabin 2
Cabin 3........Porter.............199............201

What is shown in the datagrid is:
...................Sun......Mon.....Tue.....Wed....Thur......Fri......Sat
Cabin 1........Jones....Jones...Jones...Jones
Cabin 1..................................................Smith....Smith...Smith
Cabin 2
Cabin 3.......Porter....Porter...Porter

My problem is... how can I get it to look like this:
...................Sun......Mon.....Tue.....Wed....Thur......Fri......Sat
Cabin 1........Jones....Jones...Jones...Jones...Smith....Smith...Smith
Cabin 2
Cabin 3.......Porter....Porter...Porter


Please, please help