Search results

Hi I need to concatenate some data for a report but unsure how to do it. Basically I have data that looks like this: IDProductComp 1prod 1Comp 1prod 2Comp 1prod 3Comp 1prod 4Comp 2prod 5Comp 2prod 6Comp 2prod 7 But I want it to look like this: IDProductComp 1prod 1, prod 2, prod 3, prod...

Hi, I seem to have forgotten a lot of my vba coding knowledge as I haven't used it for years so thought I would reach out for some help I have a small database that I am using to do some integrity checks to a large datafile on a monthly basis. The name and location of the file changes each...