[AccessD] reporting and multi-value fields

Susan,
Is your user using an old version of Access?  According to Roger's site,
that doesn't work for 2007.

Charlotte

On Sun, Dec 7, 2014 at 12:11 PM, Susan Harkins <ssharkins at gmail.com> wrote:

> <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
> >
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>