Macro to run until query produces no results

rotsanders

I am trying to right a macro that will check and see if a query produces any results before running. If it does have results that the macro should run through the entire workflow and then check again to see if there are any results. It should keep looping through the entire macro until there are no results left. 

Does anyone know of a good way to do this? I have messed around with iterative and batch macros, but haven't quite figured it out.

Thanks!

pcatterson

This still a fairly broad topic, but it sounds like you want to built a criteria based looping or iterative macro.  Here is a simple one that divides numbers by 2 if the largest one is greater than or equal to 5.  Instead of the greater than or equal to 5 criteria I used, your macro would use whatever query you sought to limit your macro against.  Is that what you were getting at?

Half.yxmc