transponering af tabel

If you want this in a "normal" table then I think it would need to be done in code. if I understand your data correctly then there are three records you want written into one record in the normal table. So you will need to open a recordset and loop through this saving the three records in variables. Then when you have the information for three records write a single record to your new "normal" table.

the output i want is a table like:

value1 value2 value3
.9      1      6
.7      1.5    7

hi terry thanx - even though i had hoped for a easier way to do it

I dont think there is an easier way :o(

Det kan laves vha forespørgsler a la:
Fsp1: SELECT felt2 FROM MinTabel where Felt1 = a
Fsp2: SELECT felt2 FROM MinTabel where Felt1 = b
Fsp3: SELECT felt2 FROM MinTabel where Felt1 = c

Lav en ny forespørgsel, hvor du bruger

SELECT Fsp1.felt2 AS Value1, Fsp2.felt2 AS Value2 og Fsp3.felt2 AS Value3

20 to terry for the advanced solution
10 to hekla for more straight foreward

tak til begge