[AccessD] reporting and multi-value fields

Susan Harkins ssharkins at gmail.com
Sun Dec 7 14:11:53 CST 2014


<http://www.rogersaccesslibrary.com/forum/topic449.html>

It works great!

Susan H.

On Sun, Dec 7, 2014 at 3:05 PM, Charlotte Foust <charlotte.foust at gmail.com>
wrote:

> You can use the Choose() function to parse the individual values out into
> separate fields in the query, but the result is awkward.  If they are ok
> with VBA, Split() can be used to parse the values into an array and the
> report code can handle formatting them into a list. I haven't worked with
> multi-value fields, so I'm just guessing but, another approach might be to
> create a subreport for just those values based on a query that contains
> just the PK and each parsed out value for the entire recordset using the
> Choose() function or on a temp table created the same way.
>
> Charlotte
>
> On Sun, Dec 7, 2014 at 11:44 AM, Susan Harkins <ssharkins at gmail.com>
> wrote:
>
> > >
> > >
> > >
> > > Did it ever occur to you that only two businesses in the world use the
> > term
> > > "users" as opposed to clients or customers? The two businesses are
> > > drug-dealers and software-dealers. Everyone else has more respect.
> > >
> >
> > ==========I use the term in almost every article I write. As far as I
> know,
> > no one has ever complained that I was being disrespectful, and I don't
> > pedal anything. I like users and I respect them. I have a really decent
> > lifestyle because of them. I like that I can often make their jobs a
> little
> > bit easier. I don't think I appreciate your inference that I don't.
> >
> > Not particularly useful, but I hope you feel better.
> >
> > Now, does someone have something I can actually share with this reader
> that
> > might help?
> >
> > Susan H.
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>


More information about the AccessD mailing list