Question Query

[Brandy Renenger via AccessMonster.com]

Hi everyone. I have a database of questions and answers. I have a form that
the user will answer questions on. This form is based on a query that I
would like to randomly pull questions from the questions table.

On the form, the user is populating a date field, logon field, and answer
field.

My problem is now I cannot get the query to start over where those fields
are blank. It is pulling the same 10 records I answered already.

Not sure how to do this!

 

[Guest]

How are you selecting the questions 'randomly'? If you are using rnd() in
your select statement, it probably runs through the same sequence each time
unless you reseed the random number generator using randomize, at least in
VBA.

 

[SteveS]

Hi everyone. I have a database of questions and answers. I have a form that
the user will answer questions on. This form is based on a query that I
would like to randomly pull questions from the questions table.

On the form, the user is populating a date field, logon field, and answer
field.

My problem is now I cannot get the query to start over where those fields
are blank. It is pulling the same 10 records I answered already.

Not sure how to do this!

Rogers Access Library has an example of picking random records

http://www.rogersaccesslibrary.com/download3.asp?SampleName=RandomRecords.mdb

HTH