SQL for MS Access how to pick random row from a table?

Question

I'm trying to make a Query from my Table "Questions", this table has the following fields: id(auto number), Question(text) ; Category(text), difficulty (number)

The query I'm trying to make must return one random row for every difficulty (1-5), for a given Category.

score 0 · Answer 1 · answered May 12 '15 at 21:10

0

In SQL you can do something like this:

SELECT TOP 1 * FROM Questions ORDER BY NEWID()

answered May 12 '15 at 21:10

deadflowers

63
1
13

1

Access says: "Undefined function 'NEWID' in expression." – Gord Thompson May 12 '15 at 21:30

SQL for MS Access how to pick random row from a table?

1 Answers1