Hi, Here is the problem. I have a access database that has a ton of info on the attorneys that I work for. this data has to be exported to excel, that part I can handle,(Run a query and export the query)BUT when I run the query, because the company is worldwide, some attorneys speak mor than one language, or are a member of more than one State bar. Therefore their name and other info shows up multiple times for almost each item in the query. (French, English, etc.) What I would like to do is concantenate. but how???? can anyone help?