[AccessD] reporting and multi-value fields

Bill Benson bensonforums at gmail.com
Sun Dec 7 14:55:03 CST 2014


Ok. Thanks for the response. Good luck.
On Dec 7, 2014 3:31 PM, "Susan Harkins" <ssharkins at gmail.com> wrote:

> I don't want to be accused of being disrespectful, so thank you. I don't
> think a reader who can't figure this out on his own can apply this. I don't
> think I could apply it without serious effort, but thank you.
>
> I don't expect anyone here to think like people who use Access but aren't
> developers. I often have a terrible time just understanding their
> requests/needs, let alone supplying them with a solution they can quickly
> apply. When I'm lucky, I can find an article to refer them to.
>
> I don't use these fields myself, so my lack of experience really limits my
> ability to help someone who's using them for more than a closet to store
> them in.
>
> Susan  H.
>
> On Sun, Dec 7, 2014 at 3:17 PM, Bill Benson <bensonforums at gmail.com>
> wrote:
>
> > Also, for reporting purposes, I have run a crosstab query once to get a
> max
> > case of all field values, then hard code those as report columns, the
> > quantity of unique results (values in the multivalue field) drives how
> many
> > fields are needed (if say I have to add labels, I will put more than I
> need
> > on the report and then make ones I didn't use invisible or in negative
> left
> > territory.) Using such dynamic SQL to change the query's SQL for the
> report
> > has helped me deal with additional data points as column headers.
> > On Dec 7, 2014 3:11 PM, "Bill Benson" <bensonforums at gmail.com> wrote:
> >
> > > Thought I did and you didn't give me a reply nor request for
> > > clarification. So I guess we know you respect users, how about
> > colleagues /
> > > developers / listers? :)
> > >
> > >  On Dec 7, 2014 2:48 PM, "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
>


More information about the AccessD mailing list