MS ACCESS :: PivotChart Category(x Axis) As Variable

PivotChart Only On First Page
Hi,

I have a PivotChart embedded in a Report using a master/child relationship (to the field [Course ID]). The chart works fine on the first page of the report, showing just the data for the first course. However, on subsequent pages there is no chart shown at all. If I remove the master/child link then the summarised chart appears on all pages. So whats going on? - I'm sure this worked a couple of days ago. Not sure if it failed when I ran an Office update in the last few days.

The PivotChart is a form used directly on the main report. The main report has a [Course ID] Header and footer. The PivotChart form is in the detail section.

Access 2003, recently updated, on XP.

Thanks,
Darren

View Replies ! View Related

Category And Sub Category
Trying to make up a pricing database for jobs

for instance if we have

Bonds : 15mm//17mm//20mm

Downtape : copper // aluminium

I want a drop down box where you select the category Downtape or bonds, then another drop down box showing all the possible choices for bonds if you selected bonds, but wont show you any of the down tape options.

I have been trying to work out the relationships here and been getting in a muddle so any help would be much appreicated.

Juffled

View Replies ! View Related

Top Of Category
Hi guys,

I am trying to run a query that gives me the top names of each category.
This query is getting the data from another query that here i call QrySpreadReport.
Here is the query.

SELECT [S&P Rating].[IdS&Prating], [S&P Rating].[S&P Rating], QrySpreadReport.EntityName, QrySpreadReport.Mid
FROM QrySpreadReport INNER JOIN [S&P Rating] ON QrySpreadReport.[IdS&Prating] = [S&P Rating].[IdS&Prating]
WHERE (((QrySpreadReport.Mid) In (select top 5 Mid from QrySpreadReport where QrySpreadReport.[IdS&Prating] = [S&P Rating].[IdS&Prating] order by Mid desc)))
ORDER BY [S&P Rating].[IdS&Prating] DESC , QrySpreadReport.Mid DESC;

When I run this not only it takes forever but the result is the top 5 records of the entire sample without taking in consideration the categories.

I then tried to transform que sub query QrySpreadReport that I mentioned above into a table and then re run the TOP query above. Interesting enough it worked just fine. I got the TOP 5 names for each category.

Do you guys have any idea why this is happening?
I have to say that the subquery QrySpreadReport makes reference to a huge database.

How should I run this query without having to trasnform the sub query in a table.

Many Thanks

View Replies ! View Related

Category - Sum
Dear All,

I'd like to solve the following problem.

I have a table similar to this:

material1_date1_qty1
material1_date2_qty2
...
material1_date9_qty9
...
materialN_dateX_qtyW

I'd like to define categories for date (e.g. month) and summarize the quantities:

material1_period1_qty1+2 (if date1&2 are in period1)
material1_period2_qty3+4+...+9 (if date3-9 are in period2)
...

I cannot give conditions/categories in function 'sum' - how can I solve this?

Please help!

BR
xxyy

View Replies ! View Related

Annual Axis By Week
I have events with the dates they occured in my table/query. I want to present them in a pivot chart with one axis representing the dates for each monday of the current week back to monday 51 weeks ago.

How do I get my query to show the dates for 52 consecutive mondays starting this week and going back 51 weeks along with the dates and events I have captured in my table?

View Replies ! View Related

Creating Custom PivotChart
I am trying to make a special kind of blob chart. It has to mimic the charts I have attached. I have a high number and a low number for everything that someone might want to put on the axes. The eventual goal is to have a form were the user selects what goes on each axis, and have a few other possible choices to limit how much is displayed. What I am making doesn't have to be as fancy, flexablity is more important. Can Access make this kind of graph or am I on my own, making shapes in VBA?

http://www-materials.eng.cam.ac.uk/mpsite/interactive_charts/energy-cost/generics.jpg
http://www-materials.eng.cam.ac.uk/mpsite/interactive_charts/energy-cost/metals.jpg

View Replies ! View Related

Rolling Average In PivotChart
I have a multi-pivotchart I am using to display data. Each chart shows a score for the month (taken from the date field). What I would like to do is display the three month average as a fourth column in each chart. (or at least the average alone since I only show 3 months anyways) i.e. jul, aug, sept, ave

I have an average column under grand total in pivot table view but I cannot seem to translate this into a pivotchart that displays what I describe above. I do know this is far easier with MSGraph but I want to use pivotcharts for various reasons. Any help is greatly appreciated.

View Replies ! View Related

PivotChart Export Into HTML
I've a query that gathers data from another db via ODBC. The query takes a fairly long amount of time to run. The query outputs a PivotChart. I want to save/export this PivotChart as HTML and load it up on a webpage.

I could probably do this by saving as a DataAccessPage but that would mean running the query at the time of accessing the website. So, I want to avoid this long delay by saving it as HTML.

I also want this HTML PivotChart to have the ability to "pivot" the categories by filtering/removing/adding categories that you typically do in a regular PivotChart.

The 'Save As' option does not have the HTML option. Exporting to HTML only exported the text data but not the PivotChart itself.

I'm very certain this can be done. I know this can be done because I had done it once but now can't remember. Can anyone help?

View Replies ! View Related

PivotChart - Catagory Fields
When I drop my catagory field in place on my Pivot Chart I get only the ID 'numbers' instead of the field information. Can anyone say why this may be.

Thanks

View Replies ! View Related

Queries - PivotChart View
I am made a query, but I want the query to always open up in the PivotChart View...how do I do that?

Even simpler:
I want to have a button created on the initial form that opens when database starts, which will then open the pivotchart view with the person having the ability to drag items in the chart field list to create a chart to their liking, holding the data accordingly.

Please Help!

View Replies ! View Related

Sorting Query & PivotChart
Hey everybody,

I know this question maybe be very lame but its been ages since i've touched on my sql knowledge. I've set out my database and i have 1 table which is holding the info i need to extract so that i may put it into my report. I wish to count the different values in a specific row:

Example:

Whats the problem
Behavioural
Physical
Physical
Behavioural

I wana be able to count these seperately as in:

SELECT COUNT(Client.[Whats the problem] LIKE 'Physical') AS Phy AND COUNT(Client.[Whats the problem] LIKE 'Behavioural') AS Beh
FROM Client;

Result:

Phy Beh
2 2

I havent got a clue if i'm doing it right but i need to get it to work in access 07. Also one more question i have created a Pivotchart in a form but when a create a button on my main startup form and click into the Pivotchart form all i get is the Datasheet view, how can i get it to open up the Pivotchart through the form.

Any info would be greatly appreciated Thank You.

View Replies ! View Related

Why On Earth Is My Access PivotChart Doing This?
I've written a couple queries in Access that create a BOM for components that we sell in our company. The data is withdrawn from our company system into a pyramid structure (MACOLA). Basically, all I did was recreate the "Indented Bill of Materials" report from our system.

However, when I try to run the data through a PivotChart Form, it truncates all the data (i.e. if I need 16 of one component to make another, the chart will display 16 as it should, but if I need 4.75, it will display 4). The data in the final query where the report is drawn from is correct. It displays numbers both whole and decimal.

I've looked everywhere in the properties to try to eliminate the problem, but I haven't found anything. How do I fix this?

P.S. I've developed other PivotCharts that don't have this problem. I've even rewritten the queries using a different approach with the same results. Any Ideas? Thanks in advance.

View Replies ! View Related

Pivotchart Report First Record Only
I am trying to follow this Microsoft Tutorial and it worked when I put the subform (pivotchart) into a form but not when I put it into a report. The report shows the pivotchart correctly filtered for the first record but the chart is blank for the rest of the records.

View Replies ! View Related

Graph (2 Fields From Query On X And Y-axis)
Hi!

I have this table from a query:

1 1,34
2 1,23
3 1,21
1 0,65
2 0,55
3 ...
1
2
3
1

And I want 1,2,3 at the Y-axis and the X-axis to be the other values (1,34...)

But I only get a graph that shows 1,2,3 at Y but only the value 1 at the X-axis and the 1,34-values as legends! Why?

View Replies ! View Related

Custom X-Axis On Graphs And Charts
I have attached a copy of a sample chart i wish my db to create. I have created the sample in Excel(where it was simple!).

Does anyone know a way of making Access generate the X-axis in the style shown as it would be ideal fro a set of graphs i require form my db project!

It is primarily the way in which the country covers more than one city which i am struggling to generate......the attached chart makes it a bit clearer!

The data is purely an exampe set....am not carrrying out a study of the numebr of cats dogs and hamsters in scotland, england and ireland!!!!

View Replies ! View Related

Pivot Chart (layout X-axis)
Hello all,

I've just started using a newer version of Access (2003) and have trouble using the Pivot chart.
On th X-Axis I have the years 2006-2020 and the 4 quarters in each year. They are all numbers formatted with zero decimals in a query.
But when shown in the chart the years and quarters are displayed as numbers with 2 decimals, and I don't know how to change this.

Any advise how to solve this would be great.

Greetings Ivo

View Replies ! View Related

Pivotchart With Series On Different Scale Axes
Hello all. My client has decided they like the pivotchart format better than the regular chart format, especially for its dynamic quality ( it can expand and contract with form adjustments.

One chart I am having trouble replicating in pivotchart format is one that plots two data series. One series is made of columns representing large numbers, generally several hundred or thousand, and the other data series needs to be a line which usually ranges between 0-10.

Obviously they cannot be represented on a y-axis with the same scale. This is simple to handle in MS Chart.

Is there a way to make a pivotchart with a dual-scaled y-axis, and map a data series to each one?

Thanks in advance.

View Replies ! View Related

Using PivotChart To Display Survey Data
I have this pivot chart (please see attached screenshot) that I was hoping to use to display results of a survey that was conducted by our nonprofit organization. I have it filtering by a few demographics (age, gender, parental status), and then the results of a few other questions below it. My problem is that I'm not sure what results I'm looking at -- whether they're totals of all the responses, just the "true" responses, or...?

The survey asked questions similar to what you see in the field list. Each question is a column header in my table. Then the row headers are each respondent. The choices for answers were "true", "false", or nothing. So in all the cells, i entered t, f, or nothing accordingly.

I'm not sure if I'm not using the pivot chart correctly, or if I didn't design the table for the data correctly.

View Replies ! View Related

Different Group Levels For Pivotchart In A Form
Hi,

I know we can set different group levels when we create a report, can we do the same thing for a pivotchart in a form? Thanks!

View Replies ! View Related

Chart Primary & Secondary Axis Issue
Hi

I have three figures to display in a chart.

The Total Ongoing Calls
The Ongoing Calls in Area 1
The Ongoing Calls in Area 2

Ideally the Total Ongoing Calls should equal the other two but this is never the case due to calls in wrongs areas etc. To display this I have the Total Ongoing Calls shown as an Area Chart on the Primary Axis with the other two figures shown as a Stacked Area Chart on the Secondary Axis.

This way if I manually fix the Primary and Secondary Axis Scale to the same then I can see at a glance the total in both areas and the discrepancy from the Total. Great.

The issue is that the Primary Axis will almost always be slightly higher than the Secondary Axis which means that whenever the Scale changes I would have to manually change the other Axis. Is there any way, programaticallly or otherwise, that I can link the two Axis together so that if one changes up or down the other changes with it.

Thanking everyone I am about to confuse in advance.

JC

View Replies ! View Related

Forms View By Category
Hi, I am trying to set up a form so that i can view the employees at my workplace by the scheme they are in. I have tried a number of things with no luck. If anyone could help me i wold really appreciate it. An example would be a god send. Thanks alot.

View Replies ! View Related

Category Table With Subcats
I have a table of categories with the columns: CatID | CatName | CatParentID

This way I'd like the ability to have unlimited subcategories.

My question is, how do I create a form that will let me enter the CatName with an autogenerated CatID, then enter a subcategory and select the first category as it's parent?

Something like this:

CatId | CatName | CatParentID
1 Tools 0
2 Hammers 1
3 saws 1

View Replies ! View Related