Want my pie chart to show values and percentages also

[HBH]

I am using Access 2003. I made a pie chart from a query for the sum in each catagory i am using. I want the chart to show the sum and also the percentage of the total.

[nico5038]

The best approach is to add the calculations to a query and base your chart on that query.
Using a UNION will allow different rows like:

select ID, "Year " & Year(DateField) as YearOfDate, ValueField from table
UNION
select ID, "Total", Sum(Valuefield) from table GroupBy ID;

Getting the idea ?

Nic;o)

[HBH]

The best approach is to add the calculations to a query and base your chart on that query.
Using a UNION will allow different rows like:

select ID, "Year " & Year(DateField) as YearOfDate, ValueField from table
UNION
select ID, "Total", Sum(Valuefield) from table GroupBy ID;

Getting the idea ?

Nic;o)

Thank you for your time and the idea. I couldn't get the UNION to work right, But it gave me an idea to do it another way.
I made one query to sum the total of the numbers, a second query to use that total to calculate the percent and grouped by type, and a third query that just listed the results of the second query but also had an expersion that joined the type with the percent so it would show in the legend of the pie chart.
I tried putting the querys together but the grouping and the math worked against each other and wouldn't give the right numbers or would group by too many different things and never sum up.
I think I did something easy a very hard way.

[nico5038]

The basics for a UNION are the fact that the number and the datatype of the columns from the select are equal.
To roll-up the data you can use a literal to replace a value for grouping records.
Thus:

select ID, Name, Amount from tblA
UNION
select ID, "Total", Sum(Amount) from tblA

Will give a totalline for each ID.

Nic;o)