Hello,

I have searched the forum and was not able to find a solution for my problem. Basically I was asked to provide a list of top 20+ clients (constantly changing) by accounts (different account types) at the end of each month + other information. There are around 20 queries for each client. I built a macro that runs all the queries and loop through all clients. My macro stops after looping 15 times (Error: Macro cannot loop more than 20 times)...any way to workaround that.

Thanks

What is your loop doing? I would expect to find the top 20 using the TOP predicate in a query.