MS Access Concatenate Where a Text String Is Found In Any Part Of A Field or File Name
I am needing an equation to Concatenate all files with a specific text string in it with another field that is always the same. The file names can sometimes differ in name slightly if there is more then one file per product. But the file names will always have the SkuID (IE: VH51UN45JK0) in it somewhere. Say I was needing all file paths with VH51UN45JK0 in the name. I would like to generate a Concatenate values like below.