[AccessD] reporting and multi-value fields

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
>