Joyblinks never mind some tongue-lashes; take it as fun. I once ran to chat-room to get a help, eventually i met a saucy guy and we ended up arguing and exchanged words, at last i was right.
Enough of story.

No school in this Nigeria would've thought you in-depths of anything. SQL is 1 of the most intersting and very-easy-to-learn development tool. The first set of clauses any good teacher would teach you in SQL are the DMLs (Data Manipulation Language), which are basically INSERT, SELECT, UPDATE, DELETE, then the DDLs (Data Definition Language); CREATE, DROP, ALTER etc.

However, as simple as they sound, they are too powerful to be ignored in ANY non-trivial application.

Meanwhile you can write 90% of your codes in SQL using Stored Procedures. If you're further interested I'll send you simple samples and materials.

Whatever your journey , Keep walking

The second solution above is super. I assumed you have connected to ur Db already and already making use of a Recordset,

DIm Sum as double, i as inteher
' This is what the first responder meant
for i = 1 to rs_mee.Recordset.Recordcount
sum = sum + rs_mee.RecordSet.Fields("number") 'ur column to sum
rs_mee.Recordset.Movenext
next i
F5

Launch Ur Access, Create ur table in design mode. create 3 or more columns (e.g. Password, StartDate, ExpiryDate)-Control the rest from your application. Make Ur Access db password-guarded and at the same time make provision for smart programmers like U in case they want to change system date to remain valid,

Ghengis said just my mind. The best way to tackle some issues with programming might not necessarily be the fastest or the easiest. If your table has an identity column (auto or user-defined)- good. Get ur application generate 50 random numbers for you, U can even make it variable and flexible, such that without going into your DB u can dictate the number of rows u want from the front-end. Keep the random numbers in an array/collection, then send these numbers to ur table Use something like, WHERE [id] in array[1, 50]. By this u are sure of getting ur desired result at the same time haviing a very good control over ur prog. Explore ur Language and find out a good way of Randomizing. VB uses RANDOMIZE TIMER declaration with RND().