I want to use random sampling and sampling proportional to the size. So it uses some array algorimn.
I have some result array of sampled elements and I want it make a SQL query of SELECT...
As it's imposible to do some things as declare variables, array stuff, etc on JetSQL so I need to conbine SQL with VBA
Now I cant even to do this simple query
Sub test2()
CurrentDb.Execute "SELECT number,value_a from Population where value_a>=10000000"
End Sub
get the error runtime error 3065.
My question is it possible to SELECT in sql by VBA array?
So I have in vba some array 1,2,3. And I want to SELECT in SQL 1,2,3 elements of number column, value_a.