Search results

I will give it a try when i next have to run my query which will be shortly. Thanks,

Thanks! worked great!

Hey, So i tried the script with my data and it joined some fields together with the sku so it looksl ike this 400|401|402 where the should be on each line and it didnt join any category fields together it just put them on another line. I have attached the File so you can see. Sorry to be such a...

Thanks heaps man! that is exactly what i needed! life saver! thanks guys :)

Hi, Thats exactly what i want. how do i use that xls sheet? I added lines to it but it didnt update in the concat tab?

Yeah the id matches up against my other sheet in excel that does have a sku and all the other info. this data was originally from an xml file which has been cut into about 10 different files and has linked them all together by this id number. the problem is teh program i use to import only...

Hi, Thanks for the help. but i dont think i explained it right, sorry. the first one should have a category id of 0 in a seperate field and then in the field next to it called category name text should have Adapters. then on the next line down it should have a category id of 1 and in the...

Thanks for teh info guys and the warm welcome. WHOAH that link looks complicated :S but that does sound like what i need. ive been doing some more research and it looks like i need to make a function and then somehow run it as a query. This is all just going right over my head to be honest haha...

Hi Guys, I'm new to the forum and new to Access. I tried doing a search but couldnt find the i needed. If someone could help me out that would be great. I'm sure what im wanting to do is easy so heres hoping haha. Okay pretty much my data looks like this Category_name Sku cars...