Database & Random Numbers
I am hoping somone can help me with this problem for college.
I have a database in Access and I need to extract Random records for a quiz. The way that I have done the random does work with the database as it is, but we have to allow the player to add to the database from the quiz which I have also been able to sort out.
My problem is that I don't know how to write the code so that the random takes into consideration all the records and not just the original ones.
My database currently has 111 records and I have used that for the randomize - RndNo = Int(Rnd * 111) + 1 - and it works fine, but I could end up with 120 + records.
I tried using UBound and LBound but just made a mess of it.
Can anybody help please, this assignment is finished but for this.
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL