[AccessD] Access Chart Control - Valid data sources

Borge Hansen pcs.accessd at gmail.com
Thu Oct 25 09:54:31 CDT 2018


Jack,
Thanks...
So the list must have been set up so that when you post a new subject you
don't get a copy of your own post back into your inbox.
But what happens when you are replying to a thread? Just testing to see if
I get a copy in my inbox of this ...
Sorry people...
/borge


On Fri, Oct 26, 2018 at 12:44 AM jack drawbridge <jackandpat.d at gmail.com>
wrote:

> Borge,
>
> I am receiving your emails.
>
> On Thu, Oct 25, 2018 at 10:28 AM Borge Hansen <pcs.accessd at gmail.com>
> wrote:
>
> > I found what the problem was.
> > So just for the record:
> >
> > The article points out among other things when covering how the chart
> > control by default transforms the entered rowsource into an aggregated
> > query:
> > "By default, each selected field is aggregated. For numeric and currency
> > fields, the default aggregation is *Sum*. For all other fields, the
> default
> > aggregation is *Count*. To change the aggregation, click the down-arrow,
> > and select from the list, including *None* to remove the aggregation.
> >
> > *Note*    Text fields must use the *Count* aggregation. All selected
> > *Values
> > (Y axis) * fields must either be aggregated or nonaggregated."
> > The simple query I used as rowsource was based on a local table - in
> turn a
> > result of a 'make table' query based on an aggregate query.
> >
> > Realising that the second column in the rowsource was text (Red Face) was
> > key to solving the problem.
> >
> > I had selected to format the second column in the make table query as
> > format(x,'Percent") resulting in a column showing values as xx.xx% , a
> > string expression carried thru in the make table as a text column.... and
> > referring to the article ".... Text fields *must* use the *Count*
> > aggregation."
> >
> > Removing the format(expression,"Percent") solved my problem...  Ooops!
> >
> > /borge
> >
> > PS : Does any one receive the emails I have sent today to AccessD ?
> > This is the fourth under the same heading.
> > I haven't so far gotten any copy back into my inbox....
> > Perhaps my emails don't go thru?
> > I receive all postings from everyone else - or so it appears
> > ??
> >
> >
> >
> >
> >
> >
> >
> >
> > On Thu, Oct 25, 2018 at 9:03 PM Borge Hansen <pcs.accessd at gmail.com>
> > wrote:
> >
> > > This article gives an in-depth presentation of the chart control for
> > > Access 2016 including how the control transforms the entered rowsource
> > and
> > > ways to manipulate the transformation including voiding any
> > transformation.
> > > /borge
> > >
> > >
> > > On Thu, 25 Oct 2018 at 6:52 pm, Borge Hansen <pcs.accessd at gmail.com>
> > > wrote:
> > >
> > >> Hi All,
> > >> I need a bit of advice as to what makes a valid data source for a
> Chart
> > >> Control.
> > >>
> > >> Haven't worked with the chart control for many years ..
> > >> Now using Access 2016 I want to set up a simple line chart.
> > >> I have a query with two columns: EventYear,
> > >> NumberOfFamiliesWithChildren_percent.
> > >> I thought this would be easy to set up with EventYear as the X and the
> > >> other as Y with values between 0 and 100.
> > >> When I enter the query as the rowsource on the chart control - set up
> as
> > >> a simple line chart -  the wizard (or whatever) creates what is
> called a
> > >> transformed rowsource which is the entered query grouped on EventYear
> > and
> > >> the other column expressed as either sum() or count() - or ... which
> is
> > not
> > >> what I want ... I just want the chart control to use the rowsource I
> > have
> > >> specified without doing any transformation on the rowsource.
> > >>
> > >> I've googled and nothing so far has addressed my issue.
> > >>
> > >> So, anyone who can give me a pointer to what am I missing here?
> > >> Why does the control appear to have to perform a transformation on the
> > >> entered rowsource doing a grouping, sum(), count() etc on the entered
> > >> rowsource columns?
> > >>
> > >> /borge
> > >>
> > >>
> > >>
> > --
> > 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