Forum Discussion
AdamArends
Feb 27, 2023Copper Contributor
Non-Repeating random between per unique ID
Hello Per this solution (https://www.mrexcel.com/board/threads/randbetween-per-transaction-id.1230430/), can it be brought into Access... The memory Limit of the machine means I cannot run the m...
George_Hepworth
Feb 27, 2023Silver Contributor
What part would you like help with? You've stated a requirement. Is it your plan to have some create a VBA function for you, or propose a SQL solution?
- AdamArendsFeb 28, 2023Copper Contributor
George_Hepworth Hey, thanks for the response. I would take either, really. If there is a for each SQL statement that works, that would be fine and less coding to deal with.
Thanks
- George_HepworthFeb 28, 2023Silver Contributor
For starters, see how well the ranking queries explained here can handle your requirement.