Hi,

I have one Access database table including questions and answers. Now

I need to give answer id automatically to questionID column. But I

don't know how it is best (fastest) to do?

table before

rowID answID qryrow questionID datafield

1591 12 06e 06e 06e question

1593 12 06f 06f 06f question

1594 12 answer to the question 06f

1595 12 answer 06f continue to the question 06f

1596 12 answer 06f continue to the question 06f

1597 12 06g 06g 06g new question

1598 12 answer 06g continue

1599 12 answer 06g continue

1600 12 07 07 07 question

1601 12 answer 07

1602 12 answer 07 continue

1603 12 answer 07 continue

1604 12 answer 07 continue

table after (How can I do that with query or VBA?)

rowID answID qryrow questionID datafield

1591 12 06e 06e 06e question

1593 12 06f 06f 06f question

1594 12 06f answer to the question 06f

1595 12 06f answer 06f continue to the question 06f

1596 12 06f answer 06f continue to the question 06f

1597 12 06g 06g 06g new question

1598 12 06g answer 06g continue

1599 12 06g answer 06g continue

1600 12 07 07 07 question

1601 12 07 answer 07

1602 12 07 answer 07 continue

1603 12 07 answer 07 continue

1604 12 07 answer 07 continue

column qryrow indicates only in which row inlcude question and my

probelm is how I could fill column questionID rows with correct

questionID automatically. (total rows count 150000).

Kind Regards,

Marko