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!