Macro Loop

[Joker]

I'm trying to get a macro to loop. I'm using the command RUNMACRO and the 3rd option is REPEAT EXPRESSION.

The macro's function is to get data from a qurey and copy it into an output table table. After the data is copied to the table for output, the original data is deleted from the input table.
After this is done, there are some other queries ran....

This macro needs to be repeated until there is no data left.

I am not using the expression builder correctly, and it crashes during the loop. Can anyone help me and show me how to use the this tool correctly?

 

[Uncle Gizmo]

I am not sure that you can do this with a macro, maybe it is time to look at VBA!

would you not be better off copying your records with a query, and deleting your records with a query?

 

[Joker]

Maybe I didn't explaing it well... The copying and deleting is done with queries. I was using the macro in an attempt to repeat these 2 queries as well as a few others (5 total queries to be exact).

The macro is for the collective process

I think VBA would be better, but I do not know how to use it...