Search results

I am trying to store the result of a query like the one below which is more than DLookUp will handle. Can someone tell me how to store the results of this query or like queries in a Variable? *I have been doing this by using a record set and just getting the first value the storing that...