Inserting survey questions

[vavam]

I have a database that is a survey. It loads the question ID's into the table with the questions showing on the entry form for answers, but the questions will change every six months. They still want to be able to run reports off months previous, which will be different questions.
I've thought about how to do this in a very simple way...adding the revision date to the question table and loading them according to the date of the survey using an append query.
Is there a better way to do this?

 

[liddlem]

A revision date will work, but you could also use a batch number.
eg 201101 and 201102 for the first and half half of 2011 respectively.
or simply start at 1

i would suggest that you add another table that stores some kind of reference for you.
Say that batch one was questions about pets and batch two focussed on frequent flyer points, then if you wanting to print the result about pets, users can simply choose the batch by a name that makes sense - rather than a number.