[AccessD] reporting and multi-value fields

Hey Susan
Boy oh boy!
You are becoming like the rest of us, just another old fart.

Tony Septav
Nanaimo, BC
Canada

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins
Sent: December-07-14 2:12 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] reporting and multi-value fields

<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


-----
No virus found in this message.
Checked by AVG - www.avg.com
Version: 2015.0.5577 / Virus Database: 4235/8694 - Release Date: 12/07/14