Pie Chart Problems! Can't get to link properly in a Report

[bg1907 via AccessMonster.com]

Background:
I have a report which is set up to where each page of the report is dedicated
to one particular publicly traded stock (primary key is "Ticker" in all
tables that are linked to report). For example, each page contains the
stock's symbol, a brief description, income statement, balance sheet, etc.
all coming from their own separate table feeding into the report.

I also recently created a pie chart (form) to calcuate a particular stock's
(ticker) oil/gas reserves by location (US, CANADA, INTERNATIONAL) per year.
I'm new to Access so bear with me!

Problem:
I cannot get my pie chart to recognize each separate line item (i.e. Ticker).
Instead, when I open the form, even though I have 1300 records, each time I
scan to the next record, it is not calculating based on each Ticker, but
rather the entire database. I'm not sure if this is the problem but I am
basing the pie chart form on Queries (Union & Select) and they do not have
primary keys (not even sure how to assign a primary key when creating a Union
Query).

So, when I dumped the form into the report, it was doing the same thing. I
ultimately want a pie chart in the report on each page but it is not
happening.

Here is my row source info for the chart:

SELECT ReservesChartByLocation.Location, Sum(ReservesChartByLocation.Amount)
AS SumOfAmount FROM ReservesChartByLocation GROUP BY ReservesChartByLocation.
Location;

FYI ReservesChartByLocation is a Query that is reading off a Union Query.

ANY help is appreciated and let me know if you need more info. Thanks in
advance!

 

[sailcm]

On you report, is the pie chart in the "Report Footer" or the "Ticker
Footer"? I think it needs to be in the "Ticker footer" from what you
described, or possibly in the "Detail" area. You also need to check the
"Link Child/Link Master" properties and make sure that both are set to
"Ticker".

I've never had any reason to put a chart on a form, so I can't help you there.

 

[david101]

I'm also trying to get a pie chart to work on a form. Would you mind telling
me which control to use? Thanks, David