Hi all - still a bit of a VBA dunce here but am learning, could someone take a look at this?
If I have large recordset read from Access (around 1.2 million records), how do I calculate the median of that recordset in VBA?
So, I would have:
What would go next?
If I have large recordset read from Access (around 1.2 million records), how do I calculate the median of that recordset in VBA?
So, I would have:
Code:
Sub get_median()
Set wrkjet = CreateWorkspace("", "admin", "", dbUseJet)
Set dbsfile = wrkjet.OpenDatabase("c:\research.mdb")
sql_st = "Select * FROM data Where rate_exp < 50 "
Set rstmeet = dbsfile.OpenRecordset(sql_st, dbOpenDynaset)
What would go next?