Question Query

  • Thread starter Thread starter Brandy Renenger via AccessMonster.com
  • Start date Start date
B

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!
 
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.
 
Brandy said:
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!
Click to expand...


Rogers Access Library has an example of picking random records

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

HTH
 
Back
Top