Group Query Results In Access. I dont know how to refer to the result of a query in VBA Thats because you cant do it. In this example we have only selected two fields but we are unable to select all the fields in the original table.
The main body will switch to a query terminal window. In the Add Tables list select the table you want to work with. You can now see each individual book and also all the individual orders displayed beside the book name.
In order to show Max record of all the fields create another new Query to join the result of Query1 back to Table1.
Then click the Design tab in the Query Tools contextual tab within the Ribbon. The main body will switch to a query terminal window. In the Add Tables list select the table you want to work with. Since a query can return multiple rows and columns there is no way to place the results of a query into a variable.