Recent content by Trebor423

Thanks, will be sure to include better definition next time. Yes this will get run on a scheduled interval (every 4 weeks). I will look into having this done on SQL Server. Would the algorithm change?

So after I got past the rookie things (set warnings, naming, prebuild, …) I'm running the code. It's still running. This is the second time I'm running it, I killed it the first time after 20 minutes, but it had written 92k rows so it was working as hoped for. I feel like this will work but...

Working on it, novice issues to overcome first.. will post success/question soon. Thank you!

This looks like exactly what I need, thank you!

Thanks, but when I use the split function in a query it returns 'undefined' and I don't know enough (if any) VBA to write it

I have 2 columns, one with a product, the other with a ";" delimited string associated to that product in an Access 2016 table. I need to break that string up into multiple rows and into a new table. For instance Product = 1234 and Location = abd;DEF;ghij;kLmNo into 1234 abd 1234 DEF 1234...