Updating Queries dynamically

[scube]

Hi Guys

my database is essentially a questionnaire of around 200 questions. I'm trying to add a 'light' version to it.

I've added a 'include in light verion' tick-box to all the questions and a 'light analysis' tick box on the registration page.

The questions are all genertated via queries pulling out the appropriate ones as required. What I'm tying to do is add to these queries so that if the 'perfomr light analysis' tick box is ticked only those questions that have been indicated as light are included, and if it's not all teh questions are included.

I can do either-or but not both dynamically

Can anybody help?

Thanks
scube

 

[TastyWheat]

If I understand you correctly you have a regular and a 'light' version of a questionnaire. You want to load only the 'light' questions if the "light analysis" box is ticked and all the questions if it isn't ticked.

If all that is correct it should be very easy. To load only the 'light' questions you simple add to the WHERE clause "LightQuestion=True" (depends on what you named the field of course). If you want to load every question don't use a WHERE clause at all.