I am using VBA to create a query - I then want to use VBA to get the storeNum with the highest count. For example, this is the query I use to get the counts
Now my question is, using VBA how can I capture the highest number from this query? Or the MAX() value of [CountO)?Code:SELECT [StoreNum], Count([StoreNum]) AS [CountO] FROM data GROUP BY [StoreNum] ORDER BY Count([data].[StoreNum]) DESC;