Search results

I have a query that returns a list of transaction ID's, the state in which the transaction took place, and the dollar amounts of the transactions. What my boss is looking for is a list of the top 5 transactions per state. To be clear there may not 5 transactions per state and there may not be...

I have a number of queries in Access 2007, the results of which I have imported to a table in Excel 2007. Most days, I open the Excel file, refresh the table, and the data updates. I created a simple public function in VBA to use in one of the queries. When I try to refresh the table, I get...