How to run a query and put the result into a variable
- by every_answer_gets_a_point
I am running a query from the VBA editor of Access:
select max(somerow) from sometable
I want to put the result of this query into a VBA variable. How do i do it?