Re: Create chart based on calculated totals

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

You can normalize your table structure using a union query.
SELECT 2003 As Year, 2003SalesTotal As Sales
FROM tblUnNormalized
UNION ALL
SELECT 2004, 2004SalesTotal
FROM tblUnNormalized
UNION ALL
SELECT 2005, 2005SalesTotal
FROM tblUnNormalized
UNION ALL
SELECT 2006, 2006SalesTotal
FROM tblUnNormalized;

You should consider normalizing your table structure so that you field names
don't store data values.
--
Duane Hookom
MS Access MVP

"Elaine" <songyy@xxxxxxxxxxx> wrote in message
news:1149986351.481623.179750@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Thank you for answering my question Duane.The problems is that the
years are the fields of the query. If I can thansfer the fields into
the numbers of record, then I think I can get the chart work. But in
the table structure these are the fields, how can I turn the fields
into record sets?

Elaine

Duane Hookom wrote:
You might be able to modify the chart after the fact or possibly change
your
query to be more normalized and read like:
Year Sales
2003 350
2004 550
2005 700
2006 800

--
Duane Hookom
MS Access MVP


"me" <songyy@xxxxxxxxxxx> wrote in message
news:1149969116.730062.277760@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Thanks Duane, I tried the Chart Wizard, I have only one of those four
fields shown on the chart, not all four fields at once.

Elaine


Duane Hookom wrote:
Did you try the report Chart Wizard?
--
Duane Hookom
MS Access MVP

<songyy@xxxxxxxxxxx> wrote in message
news:1149919817.569810.96790@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I want to create a chart based on the calculated totals.

My query out put is like this:

2003SalesTotal 2004 SalesTotal 2005SalesTotal
2006SalesTotal
$350 $550 $700
$800

How can I make a pie chart against these data?

Thanks in advance!

Eli





.

Relevant Pages

  • Re: SQL for Counting 1 total of 4 fields - normalization issue onl
    ... This was my attempt to normalize an existing ... Chris F ... "Duane Hookom" wrote: ... union query by record or some other way, ...
    (microsoft.public.access.queries)
  • RE: Chart using calculated field
    ... expression wants me to enter data before displaying the query results (even ... "Duane Hookom" wrote: ... A chart has a Row Source which is usually a query, table, or SQL statement. ... I would like to show the calculations in a chart for all ...
    (microsoft.public.access.reports)
  • RE: Charting performance data on a time line
    ... Here is the SQL I ended up with for the chart after ... "Duane Hookom" wrote: ... the next date and plot data if there is data to be plotted. ... Then use qgrpMMMYY in your chart query with a join that includes all records ...
    (microsoft.public.access.reports)
  • RE: Charts / Queries
    ... I used that in the query and when i went to use the chart wizard that is what ... "Duane Hookom" wrote: ... "Erik" wrote: ...
    (microsoft.public.access.reports)
  • RE: Display fields Limited on Values
    ... you could normalize with a union query. ... SELECT PersonID, Require1 as Met, "Require1" as Requirement ... "Duane Hookom" wrote: ...
    (microsoft.public.access.queries)