Display records in a table in landscape in access 2007

[neelsfer]

I have a cycling timing application. With lapracing the riders rides around a short track and in the program i enter the rider's race_number, each time they pass the finish line. I press enter and their time is stored per lap. The problem is that records are stored vertically in the field of the table.
table looks like this for a cyclist (i calculate the time from the start)

Race_No Time (HHmmss)
123 00:10:05
123 00:20:30
123 01:02:05
etc
etc
race_no is the cyclist personal number on the bike

I need the results to display per lap horisontally,
and include a lapnumber linked to the time. (The laptime should deduct from previous laptime if qone can do that)

Rider Race_no Lap1 Lap2 Lap3 Lap4 etc

Peter 123 00:10:05 00:20:30 01:02:05

Has anybody done this before?
pls help

[NeoPa]

Ordinal numbers (relative position/lap number/record number) are not handled by an RDBMS. That said some do provide such a facility via RecordSets, as well as CrossTab type queries.

Getting lap times could be done on the Raw data first by subtracting a value found using DMax() where the data is restricted to the current RaceNo and time values less than the current one.

I don't use CrossTabs, but I expect someone can help you there. It uses the TRANSFORM clause in SQL. That much I know.