Access Macro Repeat Expression using value of a field in table

Jul 30, 2012
Reaction score
I have a macro where I need to append serial number records to a table. I need to repeat this x number of times based on the value in the Field qty_to_ship of Table ProdOrderQtyToMake. I have to generate serial numbers for labels that start with a value of 0001 and end with the number of qty_to_ship value.

For example, if ProdOrderQtyToMake.qty_to_ship = 375. The serial numbers will be 0001-0375. I need to run the append query 375 times. I have the append query in a macro called mcrAppSerialNumbers.

I cannot figure out the correct syntax to enter into the Repeat Expression of my RunMacro action. I've tried so many things with DLookup and DCount and other ways but nothing works. Can someone tell me how to do this? Please?? (and thank you!)

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question