sql in ms-access [closed]

by

For a start, you need something like:

SELECT TOP 5
    ID, 
    [Case ID], 
    [Owner], 
    Rnd(-Timer()*[ID]) AS RandomRecord
FROM 
    [Cases]
ORDER BY 
    Rnd(-Timer()*[ID]);

to be used as a subquery filtered on OwnerID of your Owners’ table.

I once posted an article on this with a lot more details:

Random Rows in Microsoft Access

More Related Contents:

  1. Managing and debugging SQL queries in MS Access
  2. How do I write a full outer join query in access
  3. What’s the difference between DoCmd.SetWarnings and CurrentDB.Execute
  4. How to do INSERT into a table records extracted from another table
  5. Multiple INNER JOIN SQL ACCESS
  6. How to simulate UNPIVOT in Access?
  7. Table-less UNION query in MS Access (Jet/ACE)
  8. SQL Query – Using Order By in UNION
  9. Ms Access Query: Concatenating Rows through a query
  10. Access-SQL: Inner Join with multiple tables
  11. is there a group_concat function in ms-access?
  12. Address standardization within a database
  13. How do I implement pagination in SQL for MS Access?
  14. SQL to add column with default value – Access 2003
  15. Achieving ROW_NUMBER / PARTITION BY in MS Access
  16. How can I implement SQL INTERSECT and MINUS operations in MS Access
  17. Lightweight SQL database which doesn’t require installation [closed]
  18. Convert String to Date in MS Access Query
  19. HOW TO SELECT PREVIOUS ROW VALUE? [duplicate]
  20. MSAccess – query to return result set of earliest rows with a unique combination of 2 columns
  21. How do I create a table alias in MySQL
  22. How to save the result of a SQL query into a variable in VBA?
  23. SQL Update woes in MS Access – Operation must use an updateable query
  24. Select query with date condition
  25. Does MS access(2003) have anything comparable to Stored procedure. I want to run a complex query in MS acceess
  26. Microsoft Access – Case Query
  27. CONCAT equivalent in MS Access
  28. How do I create a decimal field in Access with Alter Table?
  29. Check if access table exists
  30. Escaping ‘ in Access SQL

Leave a Comment