I'm so close ... concatenation question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I located a Microsoft :article" that explains perfectly what I'm trying to
do, except I'm trying to do this in a query rather than a report as shown in
the article. I have to believe the same thing can be accomplised in a query,
but I need help or a pth to be poiinted towards.

Essentially, I'm trying to concatenate the contents of several fields into a
single text field separating the items by a comma. The article states much
better what I'm trying to do, relating it back to the northwind database ...
if I could just do this in a query ....

The article is located at:
http://support.microsoft.com/default.aspx?scid=kb;en-us;210163

Thanks very much in advance for any help you might provide.
 
Thanks so much, this is exactly what I needed. It's up and running but ...

When I attempt to pull the data into MS Excel, it states the it can't find
the module.

Is there some kind of "global" statement or other means of pointing Excel/MS
Query to the right place.

Details: The method of pulling the data into excel I'm using is simply
identifying my database as an external source of data. In excel I go to the
"data" menu and select "external data" then I point to my access database,
and then point to the needed query, and at this point an error message shows
up stating "undefined function <name of function> in expression".

Any help you might provide would be greatly appreciated.

thanks
 
You didn't mention that you were trying to do this from Excel!

Unfortunately, there's no way that I'm aware of to use functions that have
been defined in Access in conjunction with a query that's run from outside
of Access.
 
Sorry about that ... my original intent at the time I wrote my original
posting was to stay within Access. Then two things happened:
1) I realized my audience (ie folks in need of using a great deal of the
data I'm pulling together) are very excel literate and not very access
literate.
2) The report I wrote in Access was so miserably slow, even after I moved
everything to my local drive, that I felt I couldn't ask everyone to endure
the delays (eg 5 minutes to generate the report).

Apparently my report is accessing so many complex queries and crosstab
queries, it's a dog.

Anyway, thanks for the reply ... I guess I need to turn my attention to
improving the report performance. Care to point me in the right direction ?
Thanks very much for all the help.
 
Back
Top