Transform Recordset

Hi,

I have table where i have the following fields in datasheetview:

id | date | image | question1 | question2 | question..N

I would like to have it in this way:

id | date | image | questionnr | answer
1 01-01-2004 test.tif 1 1000 (this is the value of
field question1)

As you can see the first 3 fields remains the same, but the records of those
3 fields should be inserted for each record of the question fields. I can do
this with a union query for each questionfield, but.....

How can i do this automatically, because there are more than 500 columns.