Recent content by thisbenroberts

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...

Here is the SQL for the query. The query and the function both work fine in Access. The problem is when I try to get the results of the query to show up in Excel. SELECT TodaysINM.[Invoice Status], TodaysINM.[Rx Number], SplitString([Rx Number],"-",0) AS Expr1 FROM TodaysINM WHERE...

Quick update, if I remove the VBA function from the query, then I can select the query again in Excel.

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...