Recent content by bassmantweed

Paul, That was absolutely PERFECT. THANK YOU SO MUCH for you help.

Hey PBALDY..... Unfortunately I can not post the whole database but I have extracted the one table and taken out All of the records except 11 for demo's sake: You can see it is listed a s Fund-------------------------------------Number Capital American Fund------------------5 Capital...

Same Error :-(

I forgot to mention that when the query runs I have to hit end once for every row and when the query is complete all the rows have the fund name and #Error in the number field.

Ok. I renamed the module to something unique and that seemed to get me a little further along...... Now the query runs but I get a different error: "Runtime Error '5': Invalid proceedure call or argument." These lines are highlited in yellow when I choose debug: Concat = Left(Concat...

From the main screen I selected Modules & clicked new, then proceeded to enter the code above and changed it to my exact field & table names: (I said product & Footnote in my original question as I thougt that was easier) Table = Footnotes Field1 = Fund Field2 = Number Public Function...

Paul, Thanks so much...... i think I am almost there: When i rn the query it says : "Undefined Function 'ConCat' in expression?

My VBA skills are somewhat limited is there a place where I could learn how to do this or "borrow" some code?

I need the data to create a property file for a web application. The final output will be to a .csv and the footnotes will be wrapped in a <Sup> 1,3,5, </Sup> for the web page to list the product then then footnotes.

Thanks, I thought about the report option but I need this in a query so I can use the data for something else.

Hello All, I am trying to figure out the best was to combine fields from multiple rows into one row & field. Example: I have a table that contains footnotes and products. With a simple query I would get the following 3 rows...