I was thinking about adding a creationdate per answer (active, inactive date),

then get the total count of surveys since that date (or betwen those dates)

after that I grab the total count...

Thanks for the advice,

I thought of this solution numerous times, however I 'm in trouble when doing queries on such a database design, the queries seem to get overcomplicated. for...