report needs a csv list

  • Thread starter Thread starter Neal
  • Start date Start date
N

Neal

We have a report that lists all the items on a certificate. If there is more
than one item, it simply prints one below the other. But now the customer
wants them in a list with , separators.

Eg it now shows...

Large wooden table
Black chair
Fireside rug

but they want...

Large wooden table, Black chair, Fireside rug

How do I change it so that it will do this, I have no idea.

Thanks, Neal
 
Thanks for pointing me to that. I've read through it, and it makes sense,
but how do I trigger it to work?

How do I relate that to a field on a report/form? Do I make a field and
somehow link a property such as OnGotFocus to the code?

Thanks, Neal
 
To create the code in Dev's article:
1. Click the Modules tab in the Database window.

2. Click New. Access opens a code window.

3. Paste in everything from
'***code start***
to
'***code end***

4. Save the module.

You can now use the new function in your code, in a query, or where ever you
can use the built-in functions. Near the top of the article is an example of
the query statement you would use wiht the Northwind sample database.
 
Thanks for your help! I got it working by following your instructions.

On thing that did trip me up was that I made a new query then tried to paste
into the line (first line of the grid) but always got a syntax error.

After a while I made a new query, switched to SQL, then pasted it in and it
worked. Kind of obvious once I did it, but not at the time.

Thanks again, Neal
 
Back
Top