Is maybe a pivot table the way to go. I was just looking at the Northwind example but is it lightweight?
With Warm Regards,
Arthur D. Lorenzini
IT System Manager
Cheyenne River Housing Authority
Wk.(605)964-4265 Ext. 130
Fax (605)964-1070
alorenzini@crhanetwork.org
"Only those who will risk going too far can possibly find out how far one can go."
________________________________
From: Bill Mosca <wrmosca@comcast.net>
To: MS_Access_Professionals@yahoogroups.com
Sent: Wednesday, July 3, 2013 12:33 PM
Subject: [MS_AccessPros] Re: Something better than the chart object
Art
Access charts are absolutely terrible. I've heard some people use Excel charts instead, but I've not seen it done.
As to making changes, I usually end up starting from scratch using the wizard. But if you double-click the area you want to edit you should get a dialog box to help you.
But as I said, I hate them.
Bill Mosca
--- In mailto:MS_Access_Professionals%40yahoogroups.com, "Art" <dbalorenzini@...> wrote:
>
> Is there something better than using the Access chart object? I have one on my frmDashboard and its a Pie chart but it seems to take for ever to load.
>
> Its was supposed to be based on the following query:
>
> SELECT Count(tblUnit.UnitID) AS [# of Units], tlkpClassificationType.ClassificationTypeName AS Class
> FROM tblUnit INNER JOIN tlkpClassificationType ON tblUnit.ClassificationTypeID = tlkpClassificationType.ClassificationTypeID
> GROUP BY tlkpClassificationType.ClassificationTypeName;
>
> But when I try and edit it, it pops some sort Excel looking datasheet that I have to edit to get my chart to look right. This chart is supposed to change as the data changes but it seems I have to hardcode the changes. I must be missing something.
>
> Thanks,
>
> Art Lorenzini
> Sioux Falls, SD
>
[Non-text portions of this message have been removed]
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic () |
Tidak ada komentar:
Posting Komentar